MySQL Workbench Import and export garbled solution

1. Click Export

2. Choose CVS by default

3. Found garbled after opening

4, open with Notepad will find the encoding is normal

5, file--Save As, will find the code for UTF-8, is the MySQL table encoding method. We choose to encode to ANSI, save type to all, overwrite source file

6, now we open the CVS file is no garbled

7. We add a piece of data

8. Open with Notepad and save as UTF-8 encoding to overwrite the source file

9, with the MySQL Workbench import, found that the import results are normal

10. Can now be edited and imported directly in the CVS file

Summarize:

Use Notepad to save the source CVS file (UTF8 format) as an ANSI format and edit it in Excel before importing it in UTF8 format with Notepad.

From another point of view, there is actually no real solution to the problem. Editing in Excel can only be edited in ANSI format is itself a mishap.

Win8.1 (x64) office2013 WAMP3 (64x) (MySQL v5.7.9) MySQL Workbench 6.3 test pass

MySQL Workbench Import and export garbled solution