Solution for inputting Emoji into MySQL database

Solution for inputting Emoji into MySQL database

1. Check the tomcat background log. The core error message is as follows:
Caused by: java. SQL. SQLException: Incorrect string value: '\ xF0 \ x9F \ x98 \ x97 \ xF0 \ x9F...' for column 'content' at row 1
2. Modify the character set of the table field to utf8mb4:
Alter table UGC_REVIEW_CONTENT MODIFY 'content' text character set utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'comment content ';
3. Modify the table Character Set utf8mb4:
Alter table UGC_REVIEW_CONTENT CHARSET = utf8mb4 COMMENT = 'Post/recommended comments ';
4. Modify the character set utf8mb4 of the database:
Vim my. cnf
5. Problem analysis summary:
(I) cause