mysql command line import SQL script Chinese change question mark question

have been using the tool to connect MySQL Although small problems continue to be harmless, recently done financial cloud projects, only through the server intranet access to the database, that is, only in Linux under the command line access, in the import of Chinese when the discovery has become a question mark, after the query data resolved, hereby record the idea.

1. Check whether the SQL script file is Unicode encoded, open to see if the script file will display correctly in Chinese.

2. Check that the database is built with UTF8 encoding.

3. Under the MySQL command line, perform the status check that the server characterset and client characterset encoding are consistent (I am the problem in this step), and if not, you can set it through set names UTF8.

4. Finally, the source command is imported, and the display is normal.

mysql command line import SQL script Chinese change question mark question