MySql字符集转换

一、显示字符集相关变量值

mysql> show variables like 'character%';
+--------------------------+---------------------------------------------------------+
| Variable_name            | Value                                                   |
+--------------------------+---------------------------------------------------------+
| character_set_client     | utf8                                                    |
| character_set_connection | utf8                                                    |
| character_set_database   | gb2312                                                  |
| character_set_filesystem | binary                                                  |
| character_set_results    | utf8                                                    |
| character_set_server     | gb2312                                                  |
| character_set_system     | utf8                                                    |
| character_sets_dir       | C:\Program Files\MySQL\MySQL Server 5.1\share\charsets\ |
+--------------------------+---------------------------------------------------------+

mysql> show variables like 'collation%';
+----------------------+-------------------+
| Variable_name        | Value             |
+----------------------+-------------------+
| collation_connection | utf8_general_ci   |
| collation_database   | gb2312_chinese_ci |
| collation_server     | gb2312_chinese_ci |
+----------------------+-------------------+

二、字符集的修改

1、对单个变量进行修改

   set character_set_client=gb2312

2、同时修改几个变量

   set names 'utf8'

相当于： set character_set_client=utf8

        set character_set_result=utf8

        set character_set_connection=utf8

值得注意的是：collation_connection变量与character_set_connection是相关联的，即collation_connection的值取决于character_set_connection。