数据库编码
我数据库编码是 gbk 表编码 gbk 字段编码gbk 可是查询出来的内容是utf-8的编码,
提示错误:
[Err] 1267 - Illegal mix of collations (gbk_chinese_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
网上资料都说先查一下数据库中编码设置 然后更新一下编码设置。
我查询了 SHOW VARIABLES LIKE 'character_set_%'; :
character_set_client utf8
character_set_connection utf8
character_set_database gbk
character_set_filesystem binary
character_set_results utf8
character_set_server latin1
character_set_system utf8
character_sets_dir D:\my\myserver\share\charsets\
然后我就开始设置:
set character_set_client =gbk;
set character_set_connection =gbk;
set character_set_database =gbk;
set character_set_results =gbk;
set character_set_server =gbk;
set character_set_system =gbk;
返回信息:
[SQL] set character_set_client =gbk;
受影响的行: 0
时间: 0.000s
[SQL]
set character_set_connection =gbk;
受影响的行: 0
时间: 0.000s
[SQL]
set character_set_database =gbk;
受影响的行: 0
时间: 0.000s
[SQL]
set character_set_results =gbk;
受影响的行: 0
时间: 0.000s
[SQL]
set character_set_server =gbk;
受影响的行: 0
时间: 0.000s
[SQL]
set character_set_system =gbk;
[Err] 1238 - Variable 'character_set_system' is a read only variable
然后我在当前窗口在次查询:
character_set_client gbk
character_set_connection gbk
character_set_database gbk
character_set_filesystem binary
character_set_results gbk
character_set_server gbk
character_set_system utf8
character_sets_dir D:\my\myserver\share\charsets\
然后我新建一个窗口查询
character_set_client utf8
character_set_connection utf8
character_set_database gbk
character_set_filesystem binary
character_set_results utf8
character_set_server latin1
character_set_system utf8
character_sets_dir D:\my\myserver\share\charsets\
两个窗口中显示的结果是不一样的。。。。
最重要的是现在仍然还是报错。。。