Let MySQL support emoji emoticons

Java get to the end of the delivery of emoji expression inserted after MySQL error message, errors are as follows

Java.sql.SQLException:Incorrect string value: ' \xf0\x9f\x92\x94 ' for column ' name ' at row 1 at com.mysql.jdbc.sqlerror.c Reatesqlexception (sqlerror.java:1073) at Com.mysql.jdbc.MysqlIO.checkErrorPacket (mysqlio.java:3593) at Com.mysql.jdbc.MysqlIO.checkErrorPacket (mysqlio.java:3525) at Com.mysql.jdbc.MysqlIO.sendCommand (Mysqlio.java : 1986) at Com.mysql.jdbc.MysqlIO.sqlQueryDirect (mysqlio.java:2140) at Com.mysql.jdbc.ConnectionImpl.execSQL ( connectionimpl.java:2620) at Com.mysql.jdbc.StatementImpl.executeUpdate (statementimpl.java:1662) at Com.mysql.jdbc.StatementImpl.executeUpdate (statementimpl.java:1581)

The UTF-8 encoding can be two, three, and four bytes. The Emoju expression is 4 bytes, while MySQL UTF8 encodes up to 3 bytes, so data cannot be plugged in. The solution is to convert the MySQL encoding from UTF8 to UTF8MB4.

1: Modify MY.CNF

[Mysqld]

Character-set-server=utf8mb4

[MySQL]

Default-character-set=utf8mb4

Restart MySQL after modification

2: Command

ALTER TABLE [table_name] CONVERT to CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;

Let MySQL support emoji emoticons