Settings for the MySQL character set

1. View the current set of character sets for MySQL database

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. Temporarily change the character set of the MySQL database

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. See if the database character set has changed successfully

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. Restart the MySQL server

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

5. View the MySQL character set

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. Permanently modify the MySQL character set

[Email protected] ~]# VIM/ETC/MY.CNF
[Mysqld]
..............
Default-character-set=utf8

[Client]
Default-character-set=utf8

[MySQL]
Default-character-set=utf8

7. Restart the MySQL database

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

7. Check that the MySQL character set is in effect again

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)

This article is from the "Cloud Life" blog, make sure to keep this source http://ovcer.blog.51cto.com/1145188/1620196

Settings for the MySQL character set