运行自建存储过程,显示如下错误:
[Err] 1267 - Illegal mix of collations (gbk_bin,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='
运行 show variables like "%char%";后,显示如下:
character_set_client utf8
character_set_connection utf8
character_set_database gbk
character_set_filesystem binary
character_set_results utf8
character_set_server gbk
character_set_system utf8
character_sets_dir D:\BtSoft\WebSoft\mysql\MySQL5.5\share\charsets\
没搞懂,这个latin1哪里冒出来的。该怎么设置?
|
|