• Community
  • Products
  • Jira
  • Questions
  • The database collation 'Latin1_General_CI_AS' and table collation 'Latin1_General_CI_AS' are not supported by JIRA.

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

JIRA Health Analyser   is showing below error. Our SQL-Database collation is already set to latin1 then also its showing the below error.

So, my Question is

  1. what is the impact over JIRA from this error.
  2. What  are the steps to resolve this issue.
  3. if it wont affect the Day to Day business can we live with it.

 

image2016-7-12 19:43:47.png

 

Thanks

Yamini

1 answer

0 vote

It can cause problems with searching, user IDs, attachments, JIRA Software displays, Service Desk calls, and all sorts of places.

You might not run into any problems.  But you probably will sooner or later.  And it's quite likely that later versions of JIRA will simply not run when you try to upgrade (Confluence has already done this)

To fix it, you can backup JIRA, point it to a valid database, and re-import, or you can stop it, and use the database tools to change the collation.

Just to add to Nic's answer, (for MSSQL 2012 at least), modifying the collation to an existing database is a bit tricky as all constraint items (may include Primary Keys, Foreign Keys, and Indexes) need to be removed before the collation can be updated.  Once the collation has been updated, all of those constraints will need to be rebuilt.  Depending on the size of your JIRA instance, and whether or not you've made any custom modifications to the database itself, it's usually much simpler to stand up a new database with the correct collation set and use a JIRA Backup file to re-import the data.  When the correct collation is set at the database level, JIRA will rebuild all of the needed tables with the correct collation upon the first startup with the new database.

Suggest an answer

Log in or Sign up to answer
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Julia Dillon
Posted Apr 17, 2018 in Jira

Tell us how your team runs on Jira!

Hey Atlassian Community! Today we are launching a bunch of customer stories about the amazing work teams, like Dropbox and Twilio, are doing with Jira. You can check out the stories here. The thi...

798 views 2 19
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