数据文件导入mysql时出现中文乱码问题

 

http://www.ynpxrz.com/n773257c2024.aspx

 

从shell进入mysql，

mysql> show variables like ‘%char%';

+--------------------------+---------------+
| Variable_name | Value |
+--------------------------+---------------+
| character_set_client | gbk |
| character_set_connection | gbk |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | gbk |
| character_set_server | utf8 |
| character_set_system | utf8 |
+--------------------------+-------------+

看上图中那几个编码不是 utf8，然后一个一个设置成utf8即可：

mysql>set character_set_database=utf8; ##设置默认的字符集为utf8

但是注意， character_set_filesystem | binary |  这个不用设置为utf8