先使用以下两个命令查看编码是否一致:
SHOW VARIABLES LIKE ‘character_set_%’;
SHOW VARIABLES LIKE ‘collation_%’;
再用set命令,把编码设置一致:
如:SET collation_server = utf8_chinese_ci
再用以下命令更正某些表的编码:
ALTER TABLE <your table name> CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
转载请注明:Findever » mysql错误:Illegal mix of collations for operation