SQLSTATE[HY000]：Generalerror：1267Illegalmixof。。。

在操作时，报“error code [1267];

Illegal mix of collations (gbk_chinese_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like'

对于常见的乱码问题，有的在数据库本⾝已经为gbk或gb2312时候，但是查询出来却是乱码，这是因为mysql在连接的过程中还有道编码，因此将连接的编码设为gb2312或utf-8即可，如：

jdbc:mysql://localhost:3306/ipanel?useUnicode=true&characterEncoding=UTF-8和jdbc的参数设置是不⼀样，但⼤体相同，⽹上类似的资料很多。最重要的是这个问题：

Illegal mix of collations (gbk_chinese_ci,IMPLICIT) and (gb2312_chinese_ci,IMPLICIT) for operation '='

相信有很多⼈碰到，意思是说字符编码不⼀样，不能进⾏⽐较，也就是说数据库内部的编码都不⼀样，有的数据是gbk_chinese_ci,有的数据是gb2312_chinese_ci，因此解决此问题的核⼼就是将数据库所有的编码进⾏统⼀。解决⽅案⼀：暂时

//恶⼼的gb2312不能使⽤，需要转utf-8再继续

$where = $where . iconv(\"gb2312\解决⽅案⼆：进⼊命令⾏模式，

如果MySQL数据库已经安装好，可以使⽤下列SQL命令查看MySQL当前的字符集设置： mysql> SHOW VARIABLES LIKE 'character_set_%'; +--------------------------+----------------------------+ | Variable_name | Value |

+--------------------------+----------------------------+ | character_set_client | latin1 |

| character_set_connection | latin1 | | character_set_database | latin1 | | character_set_results | latin1 | | character_set_server | latin1 | | character_set_system | utf8 |

| character_sets_dir | /usr/share/mysql/charsets/ | +--------------------------+----------------------------+ 7 rows in set (0.00 sec)

mysql> SHOW VARIABLES LIKE 'collation_%'; +----------------------+-------------------+ | Variable_name | Value |

+----------------------+-------------------+

| collation_connection | latin1_swedish_ci | | collation_database | latin1_swedish_ci | | collation_server | latin1_swedish_ci | +----------------------+-------------------+ 3 rows in set (0.00 sec)

依次执⾏：

set character_set_client =gb2312; set character_set_connection =gb2312; set character_set_database =gb2312; set character_set_results =gb2312;

set character_set_server =gb2312;

set character_set_system =gb2312; --此处utf-8也可以然后执⾏：

SET collation_server = gb2312_chinese_ciSET collation_database = gb2312_chinese_ci

SET collation_connection =gb2312_chinese_ci

执⾏完之后，请检查mysql下每个数据库，表，字段是否都是gb2312，不是则改过来，这样⼦就不会出现

Illegal mix of collations (gbk_chinese_ci,IMPLICIT) and (gb2312_chinese_ci,IMPLICIT) for operation '='这个错误了，⽹上有资料说要重装，其实根本就不必，改动其编码即可

*****************************

PHP5.2+MYSQL5.1+APACHE2.29 IE6，firefor2,firefox3 ⽹页向MYSQL数据库插⼊记录时出现如下问题。

Illegal mix of collations (gbk_chinese_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation '=' 解决⽅法:1.注意PHP⽹站 charset=UTF-8\"

2.数据库连接设置为 utf8编码

# FileName=\"Connection_php_mysql.htm\" # Type=\"MYSQL\" # HTTP=\"true\"

$hostname_member = \"localhost\"; $database_member = \"member\"; $username_member = \"root\"; $password_member = \"123456\";

$member = mysql_pconnect($hostname_member, $username_member, $password_member) ortrigger_error(mysql_error(),E_USER_ERROR); mysql_query(\"set names gbk\"); >

请修改为 mysql_query(\"set names utf8\");

中⽂问题花去⼀天时间，请注意php和MYSQL编码发送相同问题。与MYSQL数据库编码⽆关 有问题联系