Skip to navigation
OperationalError: (1267, "Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (latin1_general_ci,EXPLICIT) for operation 'like'")
11.01.15
when you get this error when editing a ticket OperationalError: (1267, "Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (latin1_general_ci,EXPLICIT) for operation 'like'") 1. To check character set settings for your database, issue the following commands: mysql> USE trac; Database changed mysql> SHOW VARIABLES WHERE variable_name IN ('character_set_database', 'collation_database') if your trac mysql db is not | character_set_database | utf8 | | collation_database | utf8_bin than execute: ALTER DATABASE `trac_database` DEFAULT CHARACTER SET utf8 COLLATE utf8_bin; ALTER TABLE ticket CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
http://trac.edgewall.org/wiki/MySqlDb#Collationfromwhatevertoutf8_bin
Reply
Anonymous
Information Epoch 1784239021
Silence is golden.
Home
Notebook
Contact us