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.
Please refer to this doc for more info (See collation types):-
Thanks
We are tried to change but it is not changing at this moment , shall we need to create another DB and connect ?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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,
-Shankar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thank you
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.