I am using us_ascii as the default character set.
I get the following error on the piwik.php logging script:
Uncaught exception: ‘Error query: SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (ascii_general_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation ’=’’
In /Users/netmon/Sites/piwik/modules/LogStats/Db.php on line 201
You can get help from http://piwik.org (give us the full error message + your PHP and Mysql version)
Possible solution: Create the piwik tables with a specific character set for all the application, scripts etc.
(In 1011) – fixed #310 When database collation is not the default, mysql error “Illegal mix of collations”
now all tables are created with utf8 charset
(In 1014) – cleaning up the search engine parsing code, adding tests, recording UTF8 keywords in the DB rather than encoded (as tables are now utf8, refs #5730)
- adding tests in url.test.php and fixed double encoding in some edge cases
- fixed #589 Piwik fails to properly decode and store some chinese keywords (eg. from baidu.com)
- fixed #435 Exotic encoded keywords should be stored as utf-8 in the DB
- refs #575 hopefully fixed, will give it a few days of tests on piwik.org
(In 1020) – refs #5730 adding updates so that all existing tables and all fields are converted to utf8 for consistent piwik tables