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 fromUTF-8toANSI. 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 thephp trainingcolumn!
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!