The table collation: 'Latin1_General_CS_AS' is unsupported by Jira

[Devendar Gangapuram]

Hi all,

Similar issue that i am also facing from long time.

Error message is: The table collation: 'Latin1_General_CS_AS' is unsupported by Jira. The Database collation: 'SQL_Latin1_General_CP437_CI_AI' is supported by Jira.

Ours is Jira server, last time a year back we had done Jira upgration, so this issue could be cuasing after it. Now we need to upgrade Jira again but "Health ceck gives this error".

From SQL team point of view the collation was changed successfully , deleted the table with wrong collation after creating the new database. 

Please folks, help me to get rid of this error, its stopping our prod works.

Thanks a ton for fast replies,

Dev G

[Fabio Racobaldo _Herzum_]

Hey @Devendar Gangapuram ,

please take a look to the following article https://confluence.atlassian.com/jirakb/mysql-database-collation-health-check-fails-in-jira-server-943951422.html

Fabio