当创建表时,如果用普通创建方法会出现中文乱码现象
这时,可以给该字段添加下面属性:
character set gb2312
例:create table test(id int(4) primary key auto_increment, name varchar(20) character set gb2312 not null, sex varchar(2) character set gb2312 not null);
这时,可以给该字段添加下面属性:
character set gb2312
例:create table test(id int(4) primary key auto_increment, name varchar(20) character set gb2312 not null, sex varchar(2) character set gb2312 not null);