-
-
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; itemname varchar (12) not null) Character set gbk color gbk_chinese_ci; 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;
-
-
-
-
Copy code
You can also specify the gbk encoding when creating the table.
Of course, you can also modify the character set of the database through the following command
alter database da_name default character set 'charset'.-
-
Copy code
The client sends it in gbk format, you can use the following configuration:
SET character_set_client='gbk' - SET character_set_connection='gbk'
- SET character_set_results='gbk'
-
-
Copy code
The above introduces the Chinese garbled problem in the data table in pyh mysql programming Solution ,I hope to be helpful.
|
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
