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 Mar 05, 2018 in Jira Software

Jack Graves: Real Ale enthusiast with a knack for Jira Software implementation

@Jack Graves [AC] first caught our eye with his incredible breakdown of what, in his opinion, can make or break a Jira software implementation. (Read his thoughts on this thread)! In this follow...

96,842 views 4 14
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