Java/mysql character encoding

Encountered Java/mysql character encoding problem, later found to be utf-8 coding related problems,

The initial suspicion was that the error occurred in the Java SPRINGMVC related framework processing, which took a lot of time to find. This is the narrow point of thinking, should be in the collation, the way to exclude variables, to understand the problem.

Fortunately there is another test machine and database, there is no problem in the deployment of the machine.

Locate the database on the local computer.

Reference http://my.oschina.net/linland/blog/32525

http://blog.csdn.net/zhaozetu/article/details/8681350

Add a connection to the database

Useunicode=true&characterencoding=utf8

Note the "&" symbol in the URL should be escaped with the following characters:

Useunicode=true&characterencoding=utf8

　　

Specific coding problems, and then scrutiny.

Java/mysql character encoding