How to fix Database health check error "The table collation: 'SQL_Latin1_General_CP437_CI_AS' is..."

Question

Hello Everyone, I read the 'How to Resolve this' guide but I still do not understand how to get this resolved. If anyone can kindly help that would be great. Trying to get this resolved so I can complete a Jira upgrade. Since the health check is part of the per-requisites.

The error is:

The table collation: 'SQL_Latin1_General_CP437_CI_AS' is unsupported by JIRA. The Database collation: 'SQL_Latin1_General_CP437_CI_AI' is supported by JIRA.

S_ Toyo · Answer

Hello Shankar,

I am having difficulty exporting my database. When I get to the "Data source" page I am unsure what I'm looking at in the drop down menu. The guide says to make sure my old database is selected..... but I don't think I'm seeing it in this drop down list. So confused. :(

Shankar Asam {Appfire} · Answer

Hi,

You probably need to create a new database with required collation as per the document below;

https://confluence.atlassian.com/adminjiraserver073/connecting-jira-applications-to-a-database-861253039.html

and migrate JIRA from the old database (with the incorrect collation) to the new one, with the correct collation. The supported collations in SQL server are;

* SQL_Latin1_General_CP437_CI_AI
* Latin1_General_CI_AI

The following links might helpful in this regard as they contain different ways to migrate your database (xml backup and SQL DB import from old DB)

https://community.atlassian.com/t5/Jira-Software-questions/Wrong-collation/qaq-p/682537

https://confluence.atlassian.com/jirakb/how-to-fix-the-collation-of-a-microsoft-sql-server-jira-database-776646810.html?_ga=2.248744391.1147752786.1563169806-1532751805.1553999631

-Shankar