PreparedStatement Chinese garbled solution in MySQL

During the top Shard, The PreparedStatement encountered garbled Characters During database storage, which had plagued the database for a long time and finally solved the problem.

The problem code is as follows:

1. Pstmt = con. prepareStatement (INSERT_OFFLINE );
2. Pstmt. setString (1, Username );
3. Pstmt. setLong (2, MessageID );
4. Pstmt. setString (3, StringUtils. dateToMillis (NewJava. util. Date ()));
5. Pstmt. setInt (4, MsgXML. length ());
6. Pstmt. setString (5, "Chinese content ");
7. Pstmt.exe cuteUpdate ();

During debugging, the "Chinese content" in pstmt.exe cuteUpdate (); line pstmt is changed ????

The cause is that jdbc. url = jdbc: mysql: // 192.168.12.22: 3306/ts does not specify the encoding when the datasource driver is set.

You can modify it as follows:

Jdbc. url = jdbc: mysql: // 192.168.12.22: 3306/ts? CharacterEncoding = utf8

Problem Solving