用navicat查看一个表的内容时显示如下
然后进入navicat的控制台后，show variables like 'char%';命令后如下:
+--------------------------+---------------------------------------+
| Variable_name | Value |
+--------------------------+---------------------------------------+
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | latin1 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | D:\mysql-5.1.32-win32\share\charsets\ |
解决方法:把navicat的连接方式改为gb2312
再次查看:
乱码不见了
From: http://blog.chinaunix.net/uid-25135004-id-2930202.html