Home >Database >Mysql Tutorial >How to set mysql client to gbk
Mysql method to set the client to gbk: first open the my.ini file; then modify the encoding statement to "default-character-set=gbk"; finally enter "set names gbk;" in the MySQL command line That’s it.
Recommended: "mysql video tutorial"
Set the default encoding of the mysql database to gbk, solve the problem Chinese garbled characters
To solve Chinese garbled characters in Mysql, it is best to change the default encoding of the database. Generally, it is handled like this:
In the my.ini file in the mysql installation directory:
Modify below
Line 57 is changed to: default-character-set=gbk
Modify below
Line 81 is changed to: default-character- set=gbk
Enter on the MySQL command line: set names gbk;
Then enter on the MySQL command line: status; After the command, if the following picture appears: Server Db Client Conn all four are GBK, there is no problem in supporting Chinese. I have personally tested it and it is absolutely ok!
The above is the detailed content of How to set mysql client to gbk. For more information, please follow other related articles on the PHP Chinese website!