Solve the problem of Chinese garbled characters when inserting data into MySQL by Tomcat under Linux

1. Problem

The project developed using Eclipse on Windows runs fine on Windows, but when deployed to Tencent Cloud, the data inserted into the MySQL database is garbled Chinese characters

2. Solution

1. Try one

Use the insert statement directly on Linux to insert Chinese characters.

2. Attempt 2

Add useBodyEncodingForURI="true" to the tomcat configuration file server.xml, it doesn't work

3. Attempt 3

Adding URIEncoding="UTF-8" to the tomcat configuration file server.xml does not work

4. Attempt 4

Since it is an SSM framework project, a filter has been added in web.xml

<filter>
<filter-name>encodingFilter</filter-name>
<filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
<async-supported>true</async-supported>
<init-param>
<param-name>encoding</param-name>
<param-value>UTF-8</param-value>
</init-param>
</filter>
<filter-mapping>
<filter-name>encodingFilter</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>

no

5. Try five

Add ?characterEncoding=utf-8 after the jdbc path in the mybatis configuration file, success!

The modified jdbc access path is:

jdbc:mysql://localhost:3306/daad?characterEncoding=utf-8