Java+mysql Handling of emoticons

Error Environment:

MySQL 5.0: UTF8 encoding

Jdbc:mysql-connector-java-5.1.5-bin.jar

Error in case of emoticons:

Java.sql.SQLException:Incorrect string value: ' \xf0\x9f\x98\x84 ' for column

Because the emoji in some terminals, such as ios5.0 above, is expressed in four bytes, and the traditional UTF8 can only save 3 bytes, so the error.

The correct solution is as follows:

1, MySQL database upgrade to more than 5.5;

2, the database, the table, the field byte code rises from UTF8 to utf8mb4;

Refer to: HTTPS://MATHIASBYNENS.BE/NOTES/MYSQL-UTF8MB4#UTF8-TO-UTF8MB4

3, upgrade JDBC;

Lab Environment:

MySQL 5.5.39

jdbc:mysql-connector-java-5.1.30

Java+mysql Handling of emoticons