mysql编码设置

show variables like 'character_set%%'

		

[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

		

create database test character set utf8

		

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

				

alter database test character set utf8

						

alter table test character set utf8

								

alter table test modify col_name varchar(50) CHARACTER SET utf8