The table collation: 'Latin1_General_CS_AS' is unsupported by Jira

Devendar Gangapuram
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
January 31, 2023

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

 

 

1 answer

0 votes
Fabio Racobaldo _Herzum_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
February 1, 2023

Suggest an answer

Log in or Sign up to answer