用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