What to do when importing phpmyadmin with garbled characters?

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

The following introduces the solutions when encountering Chinese garbled characters.

The problem lies in the encoding.

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.

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 in the database connection file: set names 'gbk'; it will not be displayed when the web page is displayed. Garbled characters appear. In short, you specify which encoding you use.

At this point, the problem of Chinese garbled characters when using PHPmyadmin has been solved.

PHP Chinese website has a large number of free phpmyadmin introductory tutorials, everyone is welcome to learn!

The above is the detailed content of What to do when importing phpmyadmin with garbled characters?. For more information, please follow other related articles on the PHP Chinese website!