jira8.22，mysql8.0.28，Error restoring backup data

[周慧华]

the following error occurred while importing existing backup data：

Incorrect string value: '\xF0\xA0\xAE\xB7\xE5\x8E...' for column 'NEWSTRING' at row 1

[Mohamed Benziane]

Hi,

Can you look at this KB, it deals with Confluence but i think it may be helpful:

https://confluence.atlassian.com/confkb/incorrect-string-value-error-thrown-when-restoring-xml-backup-in-confluence-777009599.html

Can you make sure that your DB is properly set up:

https://confluence.atlassian.com/adminjiraserver/connecting-jira-applications-to-mysql-8-0-1018775461.html

[Nic Brough _Adaptavist_]

The string you are seeing there is (probably) a  unicode 4 byte encoded character - these were added when we ran out of space in the 3 byte scheme.  You usually see them in more recently standardised Emojis.

Sadly, I learned this the same way you have - trying to prep an upgrade, Jira issues were going missing, finding a very similar error.  Turns out one of the client's users was fond of using the 💩 emoji when creating new issues.

If it is this, then @Mohamed Benziane has given you the right answer, but I can add "look at the character set first" - if you don't set it as documented, MySQL only supports the 3 byte scheme off-the-shelf!