编译部署的MySQL别去动那些my.cnf的配置文件
(1)新建表的时候加 character set = utf8;
例如:CREATE TABLE `Student`(
`s_id` VARCHAR(20),
`s_name` VARCHAR(20) NOT NULL DEFAULT '',
`s_birth` VARCHAR(20) NOT NULL DEFAULT '',
`s_sex` VARCHAR(10) NOT NULL DEFAULT '',
PRIMARY KEY(`s_id`)
)character set = utf8;
(2)已经建好的表修改编码格式
alter table table_name convert to character set utf8;