ERROR 1267 (HY000): Illegal mix of collations (gb2312_chinese_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='
查看数据表,字符集是gb2312没错,连接字符集,服务器端字符集也全都是gb2312。怀疑是字段的字符集有问题,修改了一下,也不行。
后来创建一个临时变量,设定其字符集为gb2312,仍然不行:
set @name = in_name collate gb2312_chinese_ci;
ALTER DATABASE `yejr` CHARACTER SET gb2312;