08-01
22
Illegal mix of collations (utf8_bin,IMPLICIT) and (latin1_swedish_ci,COERCIBLE)
作者:Java伴侣 日期:2008-01-22
错误如下:
引用内容
编码问题,一个表是latin1字符集的,而传进的参数是UTF-8的,所以需要统一字符集,指令如下:
引用内容General error, message from server: "Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like'"
编码问题,一个表是latin1字符集的,而传进的参数是UTF-8的,所以需要统一字符集,指令如下:
复制内容到剪贴板
程序代码
程序代码mysql> Alter TABLE suggest CONVERT TO CHARACTER SET utf8;
Query OK, 98 rows affected (0.05 sec)
Records: 98 Duplicates: 0 Warnings: 0
Query OK, 98 rows affected (0.05 sec)
Records: 98 Duplicates: 0 Warnings: 0
