Shulou(Shulou.com)06/01 Report--

This article is about how to solve the problem of importing Chinese garbled codes into mysql database. The editor thought it was very practical, so I shared it with you as a reference. Let's follow the editor and have a look.

What about the garbled Chinese characters in mysql database? How to solve the problem of Chinese garbled after mysql data import? How to solve it? The data CSV file with Chinese fields was used in the project two days ago, and an error was reported using the workbench import file:

Looking for a long time from the Internet, it is said that the CSV file code does not match the client code. Try to convert CSV into utf8 code, but import is still not good.

Finally, use the Navicat tool to complete the import:

Encoding is particularly important, to choose 10008 (MAC-Simplified Chinese GB 2312) can not use the default utf-8, because CSV files containing Chinese are generally encoded in 10008 rather than utf8.

Wrong way:

The following mysql displays garbled codes in Chinese after import

If the code is not correct, there will be garbled!

At this point, complete the mysql data import work!

Thank you for reading! How to solve the problem of importing Chinese garbled code into mysql database is shared here. I hope the above content can help you to some extent, so that you can learn more knowledge. If you think the article is good, you can share it and let more people see it.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.