emoticons in JIRA result in "Communication breakdown" + Exception

zaphnet August 30, 2017

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?

 

screenshot-2.pngScreen Shot 2017-08-30 at 13.11.51.png

1 answer

1 accepted

1 vote
Answer accepted
Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
August 30, 2017

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 August 31, 2017

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

Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
August 31, 2017

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

eristic doyley
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
April 29, 2024

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

Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
April 29, 2024

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.

Like eristic doyley likes this
Nicolas Neumann May 16, 2024

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-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
May 17, 2024

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

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events