修改、设置mysql的编码方式

 


[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、创建数据库时设置编码

create database test character set utf8

3、创建表时设置编码

create table test(id int primary key) DEFAULT charset=utf8

4、修改数据库编码

alter database test character set utf8

5、修改表默认编码

alter table test character set utf8

文章转载自： 修改、设置mysql的编码方式  http://www.studyofnet.com/news/1266.html