Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

fix the collation of a Microsoft SQL Server JIRA database


I fix the collation of a Microsoft SQL Server JIRA database. i use  this article.

And I have problem on step 6 "Create the Database Tables". 

I run scripts and receive "Warning! The maximum key length is 900 bytes. The index 'index_ao_0ae25b_hiscf_assignee' has maximum length of 1020 bytes. For some combination of large values, the insert/update operation will fail."

what should i do next?


1 comment

Maxim, hi!

Are you sure that you use compatible version of MS SQL server?

Best regards,


Like Maxim Zaripov likes this

And what version of Jira?

Like Maxim Zaripov likes this

Jira Software 7.11.2

Jira Core 7.11.2


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

An update on Jira Software customer feedback – June 2022

Hello Atlassian Community! Feedback from customers like you has helped us shape and improve Jira Software. As Head of Product, Jira Software, I wanted to take this opportunity to share an update on...

5,088 views 18 32
Read article

Atlassian Community Events