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】