Jira fails to import an email with the emoji '😊'

Tom Van Rossom

When I send a simple email to jira (using Incoming Mail), a issue is created like configured in the Mail Handlers.

But when I send a mail with the emoji '😊' it is throwing a exception:

Caused by: java.sql.SQLException: Incorrect string value: '\xF0\x9F\x98\x8A )...' for column 'DESCRIPTION' at row 1

Even editing a issue, by adding the emoji to the description, fails.

 (link to the correct emoji: https://apps.timwhitlock.info/unicode/inspect?s=%F0%9F%98%8A)

What can I do about this? I don't want to lose emails silently.

Nic Brough -Adaptavist-

My guess is that you're using MySQL for the database?

This has a known problem with higher numbered emojis, it can't handle them and falls over spectacularly when it runs into them.  As far as I am aware, there is no fix for this either in the database or in Jira, and the only workarounds I've seen work were:

• Write your own mail handler that can strip the emojis and replace them with something MySQL can store
• Swap to PostGres