Questions about inserting Chinese characters into MySQL before taking notes

Take notes on inserting Chinese characters into MySQL

1. Script statement

Charset gbk is used before import.

Modify the table field encoding:

Note: If you use the import method to insert data, the console reports an error. If you run the command in our client tool, no error will be reported.

2. In MyBatis, the xml file is introduced into the mapper Configuration:

3. When writing the junit test class, Chinese data cannot be normally read:

Solution: add the string connection parameters.