Error Code: 1267. Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '='0.001 sec

Mysql查询报错

Error Code: 1267. Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '='0.001 sec

提示两个表的编码不一致，需要进行转换

将比较等式一边进行字符串转换，如改为ALTER TABLE 表名 CONVERT TO CHARACTER SET utf8 collate utf8_unicode_ci

posted on 2013-03-12 10:52  FanRongOS  阅读(994)  评论(0)  编辑  收藏  举报