Mysql garbled problem _ MySQL-mysql tutorial

Guide: garbled characters may occur during mysql database operations, which may cause a lot of trouble and inconvenience to your work. I will explain the garbled characters of the mysql database in the following section. The mysql garbled file uses the default character set gb231 when the database is created. Introduction: mysql databaseDuring the operation GarbledThis will cause a lot of trouble and inconvenience to your work. I will explain the garbled mysql database for you in the following article.

Mysql garbled file

This is because the default character set used when the database is created is a bit problematic for mysql after gb2312 upgrade, and setchar = gb2312 of the exported data is finally removed;

Then, the text set of setchar depends on your mysql. when cnf is started, what is the default character set file used? if the default value is gb2312, you cannot remove setchar from your character or gb2312.

So you can change setchar = gb2312 to setchar = latin1. if not, remove the default startup character set in the my. cnf file and restart mysql.