My favorites | Sign in
Project Home Downloads Wiki Issues Source
READ-ONLY: This project has been archived. For more information see this post.
Search
for
Database  
Database specific developer details
Featured, DeveloperDoc
Updated Jun 19, 2007 by thelinuxmaniac

Database Details

Database Collation = utf8_general_ci (UTF8 general Case Insensitive) Database Charset = utf8

As mysql default collation is latin_swedish_ci, when executing SQL statements involving =, LIKE, etc, the application generates the following error

MySQL error 1267: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT)

So you need to change the mysql confiuration to include utf8_general_ci as the default collation. add the following to "my.cnf" file

......
[mysqld]
....
default-character-set=utf8 
default-collation=utf8_general_ci 
....
Powered by Google Project Hosting