It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Will appreciate how best to fix DB in wrong collation.

The issue is that the DB is amongst many other DB on a SQL Server Instance.

Looking at Documentation regarding creating and configuring SQL DB for JIRA, i suspect it is not enough to just fix the collation for the DB, The instance will need to be fix as well or a work around script to tidy up all affected columns of the DB.

I will appreciate pointers and suggestions to fixing this. The Instance been shared by many DB mean that the collation fix cannot be done on the instance.

1 answer

Hi there. What collation is the database and instance currently using? It's quite possible (even highly likely) that there is no problem using a collation that is not one of the two "supported" collations. In fact, changing the Jira DB collation so that it no longer matches the instance-level collation introduces the potential for encountering a collation mismatch error due to temp tables (specifically joining on a string column in a temp table). Please see my answer to a related question about Jira and SQL Server collations for details.


For an in-depth look at changing collations in SQL Server (in general, not specific to Jira), please see my post: Changing the Collation of the Instance, the Databases, and All Columns in All User Databases: What Could Possibly Go Wrong?


Take care, Solomon...

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Jira Software

How to create Jira issus from Excel file?

When to use CSV importer When managing your processes in Jira, there are many occasions where you need to create a lot of tasks. Creating them one by one will cost you a lot of time and effort and i...

854 views 9 10
Read article

Community Events

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

Find an event

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

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you