使用MySQL客户端查询出现中文乱码解决办法

查询表数据时，出现乱码，如下：

mysql> select id,name from py_norm;
+--------------------------------------+--------------+
| id                                   | name         |
+--------------------------------------+--------------+
| 48ae7efb-3355-11e5-bdd8-5b91f16a255c | 鍒涙柊鎴愭灉     |
| eaa58aba-3347-11e5-957e-4b9504a47aba | 鍩虹鍒?      |
+--------------------------------------+--------------+

解决方法：

设置客户端查询结果编码集为gbk，即可正常显示中文：

mysql> set character_set_results='gbk';
Query OK, 0 rows affected (0.00 sec)

 另外，查看输出窗口使用字符集：

mysql> show variables like 'character_set%';
+--------------------------+-------------------------------------------+
| Variable_name            | Value                                     |
+--------------------------+-------------------------------------------+
| character_set_client     | utf8                                      |
| character_set_connection | utf8                                      |
| character_set_database   | utf8                                      |
| character_set_results    | utf8                                      |
| character_set_server     | utf8                                      |
| character_set_system     | utf8                                      |
| character_sets_dir       | F:\MySQL\MySQL Server 5.0\share\charsets\ |
+--------------------------+-------------------------------------------+
7 rows in set (0.00 sec)