Database collation to be addressed in #310. (Sounds like this may be the cause of #435.)

_Hitman47, did you try changing the collation of your tables? Did it work better then? Thanks

hey Matt, I’ve changed the collation of all tables and fields in piwik db to unicode, but the problem is still there :( so, i’m going to log the queries that piwik sends to mysql server and I’ll write here as soon as I get any result.

re-opening.

Digging up mysql logs didn’t gave any result, I couldn’t find any query mentioning the word I specified in keyword search, neither english, nor georgian. But while I was browsing piwik database I found that referer_keyword is stored in url format, so, actually, the issue can be even not associated with database collation, more possibly – with php logic behind the search process – maybe someone forgot to apply urlencode to search phrase before using it in sql query?

duplicate of #435

hitman, please post a comment in #435 giving example of georgians earch engine for which searching the keywords don’t work in piwik. we really want to fix this issue. thanks!