Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Health Check Collation Issue for Mysql 5.7+ (Jira 8.4.1)

Yi Jin Lim October 10, 2019
Health check problems detected:

Database: The table collation: 'utf8_bin' is unsupported by Jira. The Database collation: 'utf8mb4_bin' is supported by Jira.

 

I have run thru the guide according to below link.

 https://confluence.atlassian.com/kb/how-to-fix-the-collation-and-character-set-of-a-mysql-database-744326173.html 

 

However same Problem is detected during Health Check. 

1 answer

0 votes
Yi Jin Lim October 10, 2019

More info below.

Executed this code in Mysql databse:

SHOW GLOBAL VARIABLES WHERE Variable_name LIKE 'character\_set\_%' OR Variable_name LIKE 'collation%'; 

 

Output: 

character_set_clientutf8mb4
character_set_connectionutf8mb4
character_set_databaseutf8mb4
character_set_filesystembinary
character_set_resultsutf8mb4
character_set_serverutf8mb4
character_set_systemutf8
collation_connectionutf8mb4_bin
collation_databaseutf8mb4_bin
collation_serverutf8mb4_bin

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events