如何在mysql命令行终端中显示汉字？

Question

如果我设置chcp  936进mysql后，出现下面的图：

Answer 1

不行，这个字段是以utf-8的编码写入的。和gbk是无关的。

Answer 2

请看使用phpmyadmin的查询结果。

Answer 3

show variables like 'character%'  

Answer 4

从你描述的来看，是你客户端字符集和mysql的server字符集不一致。

Answer 5

mysql> show variables like 'character%';
+--------------------------+-----------------------------------------------+
| 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       | D:\BitNami\WAMPST~1.25-\mysql\share\charsets\ |
+--------------------------+-----------------------------------------------+
8 rows in set (0.00 sec)现在，我应当如何做呢？

Answer 6

http://blog.csdn.net/ACMAIN_CHM/archive/2009/05/12/4174186.aspx
MySQL 中文显示乱码

Answer 7

设置终端的字符集，才能显示出中文。不是MySQL的问题。