The database collation 'latin1_swedish_ci' and table collation 'latin1_swedish_ci' are not supported by JIRA.

Dear Atlassian Team,

I have encountered this issue under "Instance Health" plugin. I have googled and everyone says this is a bug in the "Instance Health" plugin. I want to confirm  whether it is a bug or I should fix this issue. Could you please help regarding this issue.




1 answer

1 accepted

The supported collations for the different databases can be found in this Knowledge Base article. It also describes the impact of using unsupported collation. Using an unsupported collation may work fine, but there are no guarantees.

I think your google searches have failed you.

It's not a bug in the slightest, the health check is picking up an unsupported configuration that you're using.  I suspect there's a possible bug in JIRA in that it doesn't stop an install or startup when using an unsupported collation, but it's not a bug in the healthcheck.  It's working correctly.

Petar's link explains all the stuff you need to understand why it's reporting this issue to you.

In my experience, it's caused two problems for me.  There are probably others.

  1. XML exported from systems with the wrong collation sometimes cannot be imported into other systems (whether they're using another unsupported collation or a supported one).  The XML can be cleaned and re-imported, but it's better to not to impose those extra steps
  2. When using a user external directory on a multinational site, people in one region were creating new users with perfectly valid names that contained accented characters that English doesn't use.  When they tried to log in, it would not recognise them because the collation could not cope with those characters and changed them to something it could store and use, but, of course, the users had no way of knowing what to type instead of their non-English letters.

    Both fixed by swapping to a valid collation.

Thanks for your responses.

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

3,314 views 14 20
Join discussion

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot