Hi, i have JIRA running MS SQL Server with collation 'SQL_Latin1_General_CP1_CI_AS' with versions 5.2.9, 6.1, 6.2, 6.3, 6.4 it worked finei just upgrade to 7.2.0 version and now i found the message:the database collation 'SQL_Latin1_General_CP1_CI_AS' and table collation ''SQL_Latin1_General_CP1_CI_AS' are not supported by JIRA.also, if i search documentation abount installation of JIRA with sqlserver2012 i found that the recomendation is CASE INSENSITIVEhttps://confluence.atlassian.com/adminjiraserver071/connecting-jira-applications-to-sql-server-2012-802592195.htmlso what do i have to do in this case?
Change your database collation to Latin1_General_CI_AI and the health check will no longer show error.
(Always make changes on test database in a test jira environment before doing in prod)
The change was made in test environment,
What happens if i dont change the collation?
and if i install confluence this collation: Latin1_General_CI_AI
is going to work for both?
we want JIRA database and confluence database in the same instance of sqlserver
I strongly suggest to always stay with in the supported platforms.Collation:
JIRA
Confluence
It looks like you're new here. Sign in or register to get started.
