show variables like 'character_set_%';
查看当前的字符集信息;
部分不是utf8编码导致中文乱码
set character_set_client=utf8;
set character_set_connection=utf8;
set character_set_results=utf8;
设置为utf8编码,数据显示正常
show variables like 'character_set_%';
查看当前的字符集信息;
部分不是utf8编码导致中文乱码
set character_set_client=utf8;
set character_set_connection=utf8;
set character_set_results=utf8;
设置为utf8编码,数据显示正常