MySQL character encoding settings

Through show variables like ' character_set%% '; view encoding

There are several ways to modify MySQL's encoding:

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

Add the following separately

650) this.width=650; "src="/img/fz.gif "alt=" Copy Code "style=" Margin:0px;padding:0px;border:none; "/>

[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

650) this.width=650; "src="/img/fz.gif "alt=" Copy Code "style=" Margin:0px;padding:0px;border:none; "/>

2. Setting the encoding when creating a database

Create DATABASE test character set UTF8;

3. Setting the 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 field Encoding

ALTER TABLE test modify col_name varchar (CHARACTER SET UTF8;

MySQL character encoding settings