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