How to deal with Chinese garbled characters in mysql csv

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

【Related learning recommendations: mysql tutorial(Video)】

Mysql csv Chinese garbled solution:

1. Right-click the selected csv file and select "Edit" in the pop-up menu. The system will open the csv file in text mode (Notepad);

2. After opening the csv file, perform the "Save As" operation. There will be "Encoding" at the bottom of the pop-up interface. Modify

Encoding method: Change from UTF-8 to ANSI. Save;

3. After opening it in excel, the Chinese characters are displayed normally.

If you want to know more about programming learning, please pay attention to the php training column!

The above is the detailed content of How to deal with Chinese garbled characters in mysql csv. For more information, please follow other related articles on the PHP Chinese website!