Modify MySQL default character encoding to UTF8

MySQL default encoding is Latin1, does not support Chinese, to support the Chinese need to change the database's default code to GBK or UTF8.

1. Modify Database character encoding

mysql> ALTER DATABASE mydb character set UTF8;

2. When creating a database, specify the character encoding of the database

Mysql> CREATE database mydb character set UTF8;

3. Check the character encoding of MySQL database

Mysql> Show variables like ' character% '; Query character encoding for all properties of the current MySQL database

+--------------------------+----------------------------+

| variable_name | Value |

+--------------------------+----------------------------+

| character_set_client | Latin1 |

| character_set_connection | Latin1 |

| Character_set_database | UTF8 |

| Character_set_filesystem | binary |

| Character_set_results | Latin1 |

| Character_set_server | UTF8 |

| Character_set_system | UTF8 |

| Character_sets_dir | /usr/share/mysql/charsets/|

+--------------------------+----------------------------+

4. Modify the character encoding of MySQL database

Modify the character encoding must modify the MySQL configuration file my.cnf, and then restart to take effect

There are a few places to modify MY.CNF:

Under "Client", add Default-character-set=utf8, or Character_set_client=utf8

"Mysqld" under, plus character_set_server = UTF8;

Because the above configuration, MySQL default is Latin1, if only through the command line client, MySQL Restart after the no effect.

The following is how the client command line is modified, not recommended

Mysql> set Character_set_client=utf8;

Mysql> set Character_set_connection=utf8;

Mysql> set Character_set_database=utf8;

Mysql> set Character_set_database=utf8;

Mysql> set Character_set_results=utf8;

Mysql> set Character_set_server=utf8;

Mysql> set Character_set_system=utf8;

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)

Modify MySQL default character encoding to UTF8