字符编码设置
背景:
作者在使用insert语句往表中添加记录时,出现如下错误信息
insert into System_AccountStatus(statusName,statusComment) values(“0”,”正常”),(“1”,”注销”);
Error Code: 1366. Incorrect string value: ‘\xE6\xAD\xA3\xE5\xB8\xB8’ for column ‘statusComment’ at row 1
经查询发现是创建数据库、表、字段时并没有指定字符编码
解决方法:设置字符编码,SQL语句参考如下
alter database part01 character set utf8;
alter table System_AccountStatus character set utf8;
alter table System_AccountStatus modify statusComment varchar(50) character set utf8;
扩展:创建数据库、表、字段时指定对应的字符编码
create database part01 character set utf8;
create table System_AccountStatus(
statusComment varchar(50) character set utf8 not null default ’N’ comment '状态'
)default character utf8