php mysql 中文表,php mysql表中文乱码问题如何解决

徐光霞

于 2021-03-16 18:28:43 发布

阅读量55

点赞数

文章标签： php mysql 中文表

create database zzjz CHARACTER SET gbk COLLATE gbk_chinese_ci;

create table zz_employees (employeeid int unsigned not null auto_increment primary key,name varchar(13) not null,updatetime datetime) CHARACTER SET gbk COLLATE gbk_chinese_ci;

create table zz_configitems(itemid int unsigned not null auto_increment primary key,itemname varchar(12) not null) CHARACTER SET gbk COLLATE gbk_chinese_ci;

create table zz_items(itemid int unsigned not null ,employeeid int unsigned not null,item varchar(200) not null,primary key (itemid) ,

FOREIGN KEY (itemid) REFERENCES zz_configitems(itemid) ON UPDATE CASCADE,FOREIGN KEY (employeeid) REFERENCES zz_employees(employeeid) ON UPDATE CASCADE ) CHARACTER SET gbk COLLATE gbk_chinese_ci;