Home > Article > Backend Development > The database exported by phpmyadmin is garbled
phpmyadmin exported database with garbled characters
The following introduces the solutions when encountering Chinese garbled characters.
The problem lies in the encoding problem. The character set encodings used by Chinese websites are generally gb2312, gbk, and utf8.
Because the default character set of phpmyadmin is latin1_swedish_ci. It is different from the commonly used gb2312, gbk, and utf8, so if the character set is not modified, garbled characters will appear.
Therefore, when exporting the database, pay attention to encoding issues. Because the commonly used character set is gbk_chinese_ci , we will take gbk_chinese_ci as an example to illustrate how to deal with the problem of Chinese garbled characters.
First of all, when exporting data, check whether the Chinese in the records in the data table can be displayed normally. If the Chinese displayed are all question marks like ??? , then you have to Reset the language to the database format of the encoding you use. For example, the encoding of the
database is gbk_chinese_ci and the database engine is MyISAM. Then the Language of phpMyAdmin must be set to Chinese simplified (zh -utf-8) instead of Chinese simplified (zh-gb2312-utf-8).
Similarly, if your data encoding is gb2312_chinese_ci, then the Language must be set to Chinese simplified (zh-gb2312-utf-8) instead of Chinese simplified (zh-utf-8).
Only if the language is selected correctly, Chinese garbled characters will not appear when we export SQL.
In order to check whether the exported sql file is correct, you can directly open the .sql file with Notepad and check the Chinese to see if it is garbled. If the display is normal, it means it was exported correctly.
When migrating the website or re-importing the sql file, the general MySQL character set: UTF-8 Unicode (utf8) does not need to be modified. When importing the above-exported sql script, select the "Character set of the file" utf8 (default) will do.
Note: Before entering any operation, such as inserting, querying, etc., the character set must be specified. The method adopted is to add a sentence to the database connection file: set names 'gbk'; will no longer appear garbled when displayed on the web page. In short, you specify which encoding you use.
At this point, the problem of Chinese garbled characters when using PHPmyadmin has been solved.
For more PHP related knowledge, please visit PHP Chinese website!
The above is the detailed content of The database exported by phpmyadmin is garbled. For more information, please follow other related articles on the PHP Chinese website!