为什么在mysql上面查出来的汉字都是乱码？

Question

我再Navicat 插入数据（包括汉字） 查询显示都是正常.
在服务器上查询的时候 汉字都显示为乱码 
如下： 
mysql> SELECT * FROM emp;
+-------+--------+-----------+------------+---------+
| empno | ename  | job       | hiredate   | sal     |
+-------+--------+-----------+------------+---------+
|  7369 | dong   | xiaos     | 2003-10-09 | 1500.90 |
|  7698 | å¼ æƒ    | é”€å”®      | 2005-03-12 |  800.00 |
|  7762 | åˆ˜æ˜Ž   | é”€å”®      | 2005-03-09 | 1000.00 |
|  7782 | æ
           |  7839 | çŽ‹æœˆ   | ç»ç†      | 2006-09-01 | 2500.00 |
|  8694 | æ祺   | åˆ†æžå‘˜    | 2003-10-01 | 3000.00 |
+-------+--------+-----------+------------+---------+
7 rows in set (0.00 sec)
字符集设置如下:
mysql> SHOW variables like 'char%';
+--------------------------+----------------------------------------+
| Variable_name            | Value                                  |
+--------------------------+----------------------------------------+
| character_set_client     | utf8                                   |
| character_set_connection | utf8                                   |
| character_set_database   | utf8                                   |
| character_set_filesystem | binary                                 |
| character_set_results    | utf8                                   |
| character_set_server     | utf8                                   |
| character_set_system     | utf8                                   |
| character_sets_dir       | /usr/local/mysql/share/mysql/charsets/ |
+--------------------------+----------------------------------------+
8 rows in set (0.00 sec)
请高手指点 怎么回事

Answer 1

set names 'gbk';
然后再试。http://blog.csdn.net/ACMAIN_CHM/archive/2009/05/12/4174186.aspx
MySQL 中文显示乱码

Answer 2

utf-8不支持中文吗 按照http://blog.csdn.net/ACMAIN_CHM/archive/2009/05/12/4174186.aspx进行如下设置在mysql上设置：
mysql> set names 'gbk';
ERROR 1115 (42000): Unknown character set: 'gbk'于是到my.cnf里面配置
[msyql]
# default-character-set = utf8
  default-character-set=gbk
然后重启mysql服务
启动：
$ sudo  /usr/local/mysql/bin/mysqld_safe --user=mysql &
[3] 13330
[2]   Exit 1                  sudo /usr/local/mysql/bin/mysql_safe --user=mysql
[**@mysql-test ~]$ 120803 09:22:04 mysqld_safe Logging to '/usr/local/mysql/var/mysql.err'.
120803 09:22:04 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var/再次登录mysql时 ：
[**@mysql-test ~]$ mysql -uroot -pmysql
mysql: Character set 'gbk' is not a compiled character set and is not specified in the '/usr/local/mysql/share/mysql/charsets/Index.xml' file请教大家 这该如何是好？

Answer 3

修复好了  是我的putty没有设置 
putty 右键 change setting -->window（窗口）-->translation(翻译选项) 选择UTF-8 即可