phpmyadmin exports Chinese garbled characters

When using PHPmyadmin to import and export the mysql database, the problem of Chinese garbled characters appears.

The following introduces solutions when encountering Chinese garbled characters:

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, 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 what you want. The encoding database format used, 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.

Recommended related articles and tutorials: phpmyadmin tutorial

The above is the detailed content of phpmyadmin exports Chinese garbled characters. For more information, please follow other related articles on the PHP Chinese website!