SQL Server DB Collation - Inconsistent Documentation Edited

I completed a clean install of Jira 7.3.8 using MS SQL Server as the DB on the backend. Based on the documentation in the below two reference articles, Latin1_General_CI_AI is one of the two supported Collations:





After some initial config of my 7.3.8 system, I proceeded to upgrade to 7.6.2. Post upgrade I received the following warning accessing Jira for the first time:

The following warnings should be fixed, but you can choose to ignore them and continue starting JIRA.
Database: Your database is using an unsupported collation
Your mssql database is currently using an unsupported collation: Latin1_General_CI_AI. You should change this to a supported collation:


Can anyone advise which is actually correct (Latin1_General_CI_AI or SQL_Latin1_General_CI_AI) as there is clearly a discrepancy in the documentation vs the startup check.


1 answer

0 votes

Hi David,

It seems that you are being affected by JRASERVER-59378.

At this time please vote on JRASERVER-59378 and for the time being ignore the Error in the logs and confirm the supported collation with the JIRA Instance Health Add-on per the workaround in JRASERVER-59378.



Suggest an answer

Log in or Sign up to answer
Community showcase
Published Feb 26, 2019 in Jira Software

How to prevent the propagation of unused project schemes, workflows & screens in Jira software

Atlassian ranks project attributes as the third most important factor impacting performance in the category of data. It’s not surprising, since project attributes are precisely the rules used to ma...

626 views 0 7
Read article

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