Hello ,
We have Installed latest Jira version and connected to MS SQL 2012 database Jira is up and running but not able to create project . We have checked in Instant health check up it is showing database collation error . Can any one help me to steps to resolve this error .
Thanks & Regards
Mahesh
Hi Mahesh,
As per the Atlassian, the supported collation types are, SQL_Latin1_General_CP437_CI_AI and Latin1_General_CI_AI for MS SQL database.
SQL_Latin1_General_CP437_CI_AI
Please refer to this doc for more info (See collation types):-
https://confluence.atlassian.com/adminjiraserver/connecting-jira-applications-to-sql-server-2012-938846858.html
Thanks
@Shankar Asam {Appfire}
We are tried to change but it is not changing at this moment , shall we need to create another DB and connect ?
yes @Mahesh Kallepalli , you can try that approach to create a new DB with correct collation type.
Please see if this document helps you in this regard,
https://confluence.atlassian.com/jirakb/how-to-fix-the-collation-of-a-microsoft-sql-server-jira-database-776646810.html
-Shankar
Thank you
It looks like you're new here. Sign in or register to get started.
