An error is returned when the MySQL-emoji emoticons are stored.

An error is returned when the MySQL-emoji emoticons are stored.

Solution: Replace the character set utf8 --> utf8mb4

This article reposted an article published on the public platform.

 

A developer reported a problem last week: the front-end application crawls Weibo information. A few pieces of data cannot be inserted every day. Application log display: java. SQL. SQLException: Incorrect string value: '\ xF0 \ x9F \ x92 \ xAA ",... 'For column' raw _ json' at row 1, exception: org. springframework. jdbc. uncategorizedSQLException: The raw_json field is shown as follows:

Http://punchdrunker.github.io/iOSEmoji/table_html/flower.html

Because it is an online production business, you must first perform the test in the test environment. Avoid peak business hours and apply for shutdown window operations online.