How to query mysql encoding: 1. Use the "show variables like 'character_set_database';" statement to view the database encoding format; 2. Use the "show create table data table name;" statement to view the data table encoding.
The operating environment of this tutorial: windows7 system, mysql8 version, Dell G3 computer.
View the mysql database and table encoding format
1. View the database encoding format
mysql> show variables like 'character_set_database';
2. View the data table Encoding format
mysql> show create table <表名>;
Expand knowledge: Modify the encoding format
1. Modify the encoding format of the database
mysql>alter database <数据库名> character set utf8;
2. Modify the encoding format of the data table
mysql>alter table <表名> character set utf8;
3. Modify the field encoding format
mysql>alter table <表名> change <字段名> <字段名> <类型> character set utf8; mysql>alter table user change username username varchar(20) character set utf8 not null;
[Related recommendations: mysql video tutorial]
The above is the detailed content of How to query mysql encoding. For more information, please follow other related articles on the PHP Chinese website!