emoticons in JIRA result in "Communication breakdown" + Exception

[zaphnet]

Which Emoticons are supported?

When adding "THINKING FACE" "\xF0\x9F\xA4\x94"

The System fails with core dump with JIRA 7.0.2

useUnicode=true&characterEncoding=UTF8&sessionVariables=storage_engine=InnoDB

Which verison of unicode is supported by which version of JIRA?

[Nic Brough -Adaptavist- · Accepted solution]

MySQL doesn't support those extended emoji characters with JIRA.

Or the other way around - JIRA doesn't support them when backed by MySQL.

I don't know which one of those the fault lies with, but it's one of the two.  Either way, you can't use extended emojis with JIRA.

[zaphnet]

Thanks! - Migration to Postgres in the backlog - just got bumped up...

[Nic Brough -Adaptavist-]

Ah, good, that's the first solution I would have offered!

[ERROR: Authentication failed due to the flow token expired]

is that a bug which is going to be solved? Or is it by design? (very strange decision if it is)

[Nic Brough -Adaptavist-]

Welcome to the Atlassian Community!

No, it's a known problem with MySQL.  But fixable by configuring your MySQL to handle it correctly. 

At the time the original question was asked, Jira would work with MySQL installs that were not set up correctly (which, annoyingly, is still the default settings for a  new MySQL install).

But later versions will not, so the problem has mostly gone away - new and upgrading users must correct the settings on their MySQL database before they can use Jira.

[Nicolas Neumann]

Hi Nic,

thanks for this advise!

Could you provide us the necessary configuration on MySQL, please?

We've got the same issue still. 

[Nic Brough -Adaptavist-]

Hi Nicolas,

The settings for your MySQL server can be found in the installation guide at https://confluence.atlassian.com/adminjiraserver/connecting-jira-applications-to-mysql-8-0-1018775461.html