MySQL字符集的设置

【前提】

winxpsp3

mysql5.1

【步骤】

1.进入MySQL Command Line Client;

2.命令：

mysql> show variables like 'character%';
+--------------------------+---------------------------------------------------------+
| Variable_name            | Value
     |
+--------------------------+---------------------------------------------------------+
| character_set_client     | latin1
     |
| character_set_connection | latin1
     |
| character_set_database   | latin1
     |
| character_set_filesystem | binary
     |
| character_set_results    | latin1
     |
| character_set_server     | latin1
     |
| character_set_system     | utf8
     |
| character_sets_dir       | C:/Program Files/MySQL/MySQL Server 5.1/share/charsets/ |
+--------------------------+---------------------------------------------------------+
8 rows in set (0.00 sec)

mysql> set names 'gbk';
Query OK, 0 rows affected (0.02 sec)

mysql> show variables like 'character%';
+--------------------------+---------------------------------------------------------+
| Variable_name            | Value
     |
+--------------------------+---------------------------------------------------------+
| character_set_client     | gbk
     |
| character_set_connection | gbk
     |
| character_set_database   | latin1
     |
| character_set_filesystem | binary
     |
| character_set_results    | gbk
     |
| character_set_server     | latin1
     |
| character_set_system     | utf8
     |
| character_sets_dir       | C:/Program Files/MySQL/MySQL Server 5.1/share/charsets/ |
+--------------------------+---------------------------------------------------------+
8 rows in set (0.00 sec)

它相当于下面三条命令：

SET character_set_client = gbk;
SET character_set_results = gbk;
SET character_set_connection = gbk;

其它的五项也可以分别设置。

 

MySQL对字符集的支持包含两个方面：

一是字符集（character set）；二是排序方式（collation）

 

mysql> show variables like 'character_set_%';
+--------------------------+---------------------------------------------------------+
| Variable_name            | Value
     |
+--------------------------+---------------------------------------------------------+
| character_set_client     | gbk
     |
| character_set_connection | gbk
     |
| character_set_database   | latin1
     |
| character_set_filesystem | binary
     |
| character_set_results    | gbk
     |
| character_set_server     | latin1
     |
| character_set_system     | utf8
     |
| character_sets_dir       | C:/Program Files/MySQL/MySQL Server 5.1/share/charsets/ |
+--------------------------+---------------------------------------------------------+
8 rows in set (0.01 sec)

mysql> show variables like 'collation_%';
+----------------------+-------------------+
| Variable_name        | Value             |
+----------------------+-------------------+
| collation_connection | gbk_chinese_ci    |
| collation_database   | latin1_swedish_ci |
| collation_server     | latin1_swedish_ci |
+----------------------+-------------------+
3 rows in set (0.00 sec)

 

修改表的字符集：

mysqls>alter table UserInfo default charset gbk;

 

还可以用:

alter TableName chang 'FieldName','FieldName'...

修改列字符集。

【作者 zwdl】