mysql客户端编码方式_使用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)

分享到：

2015-07-26 13:32

浏览 427

评论