要求mysql数据库使用utf8编码,看了网上好多帖子,可是搞不定mysql> show variables like '%char%';     
+--------------------------+---------------------------------------------+
| Variable_name            | Value                                       |
+--------------------------+---------------------------------------------+
| character_set_client     | latin1                                      | 
| character_set_connection | latin1                                      | 
| character_set_database   | utf8                                        | 
| character_set_filesystem | binary                                      | 
| character_set_results    | latin1                                      | 
| character_set_server     | utf8                                        | 
| character_set_system     | utf8                                        | 
| character_sets_dir       | /opt/aimm/aimm/mysql5/share/mysql/charsets/ | 
+--------------------------+---------------------------------------------+
mysql> SHOW VARIABLES LIKE 'collation_%';
+----------------------+-------------------+
| Variable_name        | Value             |
+----------------------+-------------------+
| collation_connection | latin1_swedish_ci | 
| collation_database   | utf8_general_ci   | 
| collation_server     | utf8_general_ci   | 
+----------------------+-------------------+怎么设置,才能得到如下的效果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       | /opt/aimm/aimm/mysql5/share/mysql/charsets/ | 
+--------------------------+---------------------------------------------+
mysql> SHOW VARIABLES LIKE 'collation_%';
+----------------------+-------------------+
| Variable_name        | Value             |
+----------------------+-------------------+
| collation_connection | utf8_general_ci   | 
| collation_database   | utf8_general_ci   | 
| collation_server     | utf8_general_ci   | 
+----------------------+-------------------+
累似这样的操作
[mysql] default-character-set=gb2312 
[mysqld] 
default-character-set=gb2312 都做了
...............跪求高人指点..........