Create
cancel
Showing results forย 
Search instead forย 
Did you mean:ย 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Jira fails to import an email with the emoji '๐Ÿ˜Š' Edited

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.

1 answer

1 accepted

1 vote
Answer accepted

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

Still no solution for this issue? It still exists in current Jira version with MySQL :o(

You can now swap the collation of MySQL to one that supports the emojis.

Serious? You really suggest to switch to a new database system to fix this issue? Shouldn't there be a way to handle this in the application where it happens?

It's not happening in the application.  The error is from the database telling the application it can't handle the data the application has asked it to store.

Suggest an answer

Log in or Sign up to answer
TAGS

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you