MySQL字元集的設定

標籤：mysql字元集

1. 查看MySQL資料庫當前設定的字元集

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       | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
8 rows in set (0.00 sec)

2.臨時更改MySQL資料庫的字元集

mysql> SET character_set_client = utf8;
Query OK, 0 rows affected (0.00 sec)

mysql> SET character_set_connection = utf8;
Query OK, 0 rows affected (0.00 sec)

mysql> SET character_set_results = utf8;
Query OK, 0 rows affected (0.00 sec)

mysql> SET character_set_server = utf8;
Query OK, 0 rows affected (0.00 sec)

 

3.查看資料庫字元集是否更改成功

mysql> SHOW VARIABLES LIKE ‘character%‘;
+--------------------------+----------------------------+
| Variable_name                    | Value                                    |
+--------------------------+----------------------------+
| character_set_client           | utf8                                       |
| character_set_connection | utf8                                        |
| character_set_database    | latin1                                      |
| character_set_filesystem   | binary                                     |
| character_set_results        | utf8                                        |
| character_set_server         | utf8                                        |
| character_set_system       | utf8                                        |
| character_sets_dir             | /usr/share/mysql/charsets/     |
+--------------------------+----------------------------+
8 rows in set (0.00 sec)

4.重啟mysql伺服器

[[email protected] ~]# service mysqld restart
Stopping mysqld:                                           [  OK  ]
Starting mysqld:                                             [  OK  ]

5.查看MySQL字元集

 

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       | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
8 rows in set (0.00 sec)

6.永久修改MySQL字元集

[[email protected] ~]# vim  /etc/my.cnf
[mysqld]
..............
default-character-set=utf8

[client]
default-character-set=utf8

[mysql]
default-character-set=utf8

7.重新啟動MySQL資料庫

[[email protected] ~]# service mysqld restart
Stopping mysqld:                                           [  OK  ]
Starting mysqld:                                            [  OK  ]

 

7.再次查看MySQL字元集設定是否生效

mysql> SHOW VARIABLES LIKE ‘character%‘;
+--------------------------+----------------------------+
| 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       | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
8 rows in set (0.00 sec)

本文出自 “雲人生” 部落格，請務必保留此出處http://ovcer.blog.51cto.com/1145188/1620196

MySQL字元集的設定