|
Database
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 .... |