求教：mysql 编码问题

Question

mysql编码

Answer 1

show variables like 'char%'; 

Answer 2

set names 'gbk'先尝试一下。http://blog.csdn.net/ACMAIN_CHM/archive/2009/05/12/4174186.aspx
MySQL 中文显示乱码

Answer 3

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       | /u01/mysql/share/charsets/ |
+--------------------------+----------------------------+

Answer 4

是在insert还是select的时候出错？