使用记事本打开Mysql安装目录下的“my.ini”文件.(查看default-character-set是否为utf-8)
[client]
port=3306
[mysql]
default-character-set=utf8
1.数据库中输入下列语句进行查询
show variables like '%character%';
2.设置字符集
set character_set_database=utf8;
set character_set_server=utf8;
set character_set_client=utf8;
set character_set_connection=utf8;
3.设置显示中文的配置
set character_set_results=gbk;
完成后中文显示即可正常!