PKP Bugzilla – Bug 1640
Unable to publish issue
Last modified: 2005-05-23 12:18:35 PDT
We are moving to Git Issues for bug tracking in future releases. During transition, content will be in both tools. If you'd like to file a new bug, please create an issue.
DB Error: Illegal mix of collations (utf8_general_ci,COERCIBLE) and
(latin1_swedish_ci,IMPLICIT) for operation 'locate'
Secondary problem on this site. Can
't enter Decsion
[Please refrain from including usernames and passwords to live sites in Bugzilla
reports; I strongly suggest you change your site's password immediately (if it
is indeed a live site).]
A patch to add UTF-8 support to ADOdb's MySQL driver was missed in the last
ADOdb library upgrade. This will cause the system to be installed improperly if:
the database server is MySQL, UTF-8 database support is selected during install,
and the MySQL server is configured such that UTF-8 is not the default character set.
Solutions for existing installations:
1) If UTF-8 database support is not needed, change "connection_charset" and
"database_charset" from "utf8" to "Off" in config.inc.php
2) If UTF-8 database support is needed, alter the database tables to UTF-8:
ALTER DATABASE my_database DEFAULT CHARACTER SET 'utf8';
ALTER TABLE articles CONVERT TO CHARACTER SET 'utf8';
...etc. (altering each table)