Question

[php]Mysql error description: Illegal mix of collations (gb2312_chinese_ci,IMPLICIT) and

Mysql error description: Illegal mix of collations (gb2312_chinese_ci,IMPLICIT) and (gbk_chinese_ci,IMPLICIT) for operation '='
是什么意思怎么解决，我刚才建立索引来的
gb2312_chinese_ci怎么能在数据库里面改啊
http://www.vpnall.com/2009/03/mysql-error-1267/

Answer 1

数据库的的编码不一样，造成冲突引起的,

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;

set collation_server = gb2312_chinese_ci;

set collation_database = gb2312_chinese_ci;

set collation_connection =gb2312_chinese_ci;