Mysql character encoding Setup method _mysql

Variables like ' character_set%% ' by show

There are several ways to modify MySQL encoding:

1. Modify My.ini (under Windows) or/ETC/MY.CNF (under Linux) via configuration files

Add the following separately

[Mysqld]
Character_server_set=utf8
[MySQL]
default-character-set=utf8
[Mysql.server]
Default-character-set=utf8
[Mysql_safe]
Default-character-set=utf8
[client]
Default-character-set=utf8

2. Set encoding when creating a database

Create DATABASE test character set UTF8;

3. Set encoding when creating a table

CREATE TABLE test (ID int primary key) DEFAULT Charset=utf8;

4. Modify the database encoding

ALTER DATABASE test character set UTF8;

5. Modify table Default encoding

ALTER TABLE test character set UTF8;

6. Modify the field encoding

ALTER TABLE test modify col_name varchar (m) CHARACTER SET UTF8;

The above is a small set to introduce the MySQL character coding method, I hope to help you!