MySQL Database import Chinese garbled problem solving scheme

MySQL database Chinese characters garbled how to do ? How to solve the problem of Chinese garbled after MySQL data import? How to solve? The first two days of the project used to contain Chinese text field data CSV file, using Workbench import file Error:

From the internet for a long time is said to be CSV file encoding and client code mismatch problem, try to convert CSV to UTF8 encoding, import or not.

Finally, use the Navicat tool to complete the import:

Encoding is particularly important, to choose 10008 (mac-simplified Chinese GB 2312) cannot use the default Utf-8 because CSV files with Chinese are generally encoded in 10008 rather than UTF8.

Error mode:

The following MySQL import after the Chinese display garbled

Coding is wrong will appear garbled phenomenon!!!

This completes the MySQL data import work!

MySQL database in the Chinese garbled problem solved completely!