1.表尾加入default charset = utf8
CREATE TABLE `shs_student` (
`id` int NOT NULL,
`name` varchar(255) DEFAULT NULL,
`sex` varchar(4) DEFAULT NULL,
`chinese` float DEFAULT NULL,
`english` float DEFAULT NULL,
`maths` float DEFAULT NULL
);
CREATE TABLE `shs_student` (
`id` int NOT NULL,
`name` varchar(255) DEFAULT NULL,
`sex` varchar(4) DEFAULT NULL,
`chinese` float DEFAULT NULL,
`english` float DEFAULT NULL,
`maths` float DEFAULT NULL
)default charset = utf8;
2.已经添加了的表
执行语句:
ALTER TABLE shs_student CONVERT TO
CHARACTER SET utf8 COLLATE utf8_unicode_ci;
3.直接修改数据库的字符串编码属性
执行语句:
ALTER DATABASE databasename CHARACTER SET utf8 COLLATE utf8_unicode_ci;