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

This article is to share with you about the solutions to Chinese garbled in mysql csv. 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.

Mysql csv Chinese garbled solution: first of all, right-click the selected csv file, and select "Edit" in the pop-up menu; then open the csv file, "Save as" operation; finally, change [UTF-8 to ANSI] and keep it.

Solutions to Chinese garbled codes in mysql csv:

1. Right-click the selected csv file and select "Edit" from the pop-up menu, and the system will open the csv file in text (notepad).

two。 After opening the csv file, perform the "Save as" operation, and there is a "code" at the bottom of the pop-up interface to modify it.

The coding method can be changed from UTF-8 to ANSI. Save

3. After opening it with excel, the display of Chinese characters is normal.

Thank you for reading! On the mysql csv Chinese garbled solutions to share here, I hope the above content can be of some help to you, 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.