MySQL:Illegal mix of collations (utf8_general_ci,COERCIBLE) and (gbk_chinese_ci,IMPLICIT) for operation ‘=’
-- 查看编码
show table status;
show variables like "%character%";
show variables like "%collation%";
-- 设置编码utf8/gbk
set character_set_database = utf8;
set character_set_server = utf8;
set character_set_client = utf8;
set character_set_connection = utf8;
set character_set_results = utf8;
-- 解决方案:
-- 1、在my.ini中添加
[mysqld]
character-set-server=utf8
[mysql]
default-character-set=utf8
[client]
default-character-set=utf8
-- 2、url加上参数指定编码
characterEncoding=utf8