latin1字符集在navicat下显示乱码（mysql）

用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