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;
复制代码
也可以在创建表的时候指定gbk的编码。
当然，也可以通过如下指令修改数据库的字符集
alter database da_name default character set 'charset'.
复制代码
客户端以 gbk格式发送 ，可以采用下述配置:
set character_set_client='gbk' set character_set_connection='gbk' set character_set_results='gbk'
复制代码
以上介绍了pyh mysql编程中数据表出现中文乱码问题的解决方法，希望对大家有所帮助。