mysql字符集问题.

用show variables like '%char%' 查看mysql的参数,结果应如下:
mysql> show variables like '%char%';
+--------------------------+--------------------------+
| Variable_name            | Value                    |
+--------------------------+--------------------------+
| character_set_client     | gbk                      |
| character_set_connection | gbk                      |
| character_set_database   | utf8                     |
| character_set_filesystem | binary                   |
| character_set_results    | gbk                      |
| character_set_server     | utf8                     |
| character_set_system     | utf8                     |
| character_sets_dir       | D:\MySQL\share\charsets\ |
+--------------------------+--------------------------+
这样才能在command line client中正确显示中文.刚开始,将所有参数都配成utf8.
结果在command line client中查看,都是乱码,但程序正常显示.原因:command line client所用的字符集为:gbk.