Solution: Convert the MySQL encoding from UTF8 to UTF8MB4. Requires >= MySQL 5.5.3 version, from the library must be 5.5, the lower version does not support this character set, replication error stop MySQL Server service
Modify MY.CNF or Mysql.ini
[Client]
Default-character-set = Utf8mb4
[MySQL]
Default-character-set = Utf8mb4
[Mysqld]
Character-set-client-handshake = FALSE
Character-set-server = Utf8mb4
Collation-server = Utf8mb4_unicode_ci
init_connect= ' SET NAMES utf8mb4 '
Restart MySQL Server, check character set mysql> SHOW VARIABLES WHERE variable_name like ' character\_set\_% ' OR variable_name like ' Collatio n% '; Modify Database Character set: ALTER db database_name CHARACTER set = UTF8MB4 COLLATE = utf8mb4_unicode_ci; Modify the character set of the table: ALTER table table_name CONVERT to CHARACTER set utf8mb4 COLLATE utf8mb4_unicode_ci; Modify the character set of a field: ALTER TABLE table_name Change column_name column_name VARCHAR (191) CHARACTER set UTF8MB4 COLLATE utf8mb4_unicode _ci; If only a field needs to modify the character set of that field, you can add the connection parameters of the server connection database connector/j, not the characterencoding parameter. When this parameter is not added, the default value is AutoDetect.
Let MySQL support emoji emoticons