Mysql查询报错
Error Code: 1267. Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=' 0.001 sec
提示两个表的编码不一致,需要进行转换
将比较等式一边进行字符串转换,如改为“CONVERT(table-colum USING utf8) COLLATE utf8_unicode_ci”
Mysql查询报错
Error Code: 1267. Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=' 0.001 sec
提示两个表的编码不一致,需要进行转换
将比较等式一边进行字符串转换,如改为“CONVERT(table-colum USING utf8) COLLATE utf8_unicode_ci”