How to add Chinese characters to mysql

How to add Chinese characters to mysql: first check the encoding of the database; then modify the character set of database jats003, the code is [alter database jats003 character set utf8].

Mysql method of adding Chinese characters:

Case one (database encoding):

1 , Check the encoding of the database: show create database jats003;

2. Modify the character set of database jats003: alter database jats003 character set utf8;

situation 2 (data table encoding):

1. View the character set of the data table show create table t_learn_student;

2. Modify the character set of the data table t_learn_student: alter table t_learn_student character set utf8;

Related learning recommendations: mysql tutorial

The above is the detailed content of How to add Chinese characters to mysql. For more information, please follow other related articles on the PHP Chinese website!