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

[技術事業群-研發七處-Mobile二部-數字應用組Steve_Liao]

Health check problems detected:

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

I solved the issue that follow the confluence, you can try it.

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

SELECT CONCAT('ALTER TABLE `', table_name, '` MODIFY `', column_name, '` ', DATA_TYPE, '(', CHARACTER_MAXIMUM_LENGTH, ') CHARACTER SET utf8mb4 COLLATE utf8mb4_bin', (CASE WHEN IS_NULLABLE = 'NO' THEN ' NOT NULL' ELSE '' END), ';')

FROM information_schema.COLUMNS

WHERE TABLE_SCHEMA = ‘jira’

AND DATA_TYPE = 'varchar'

AND

(

    CHARACTER_SET_NAME != 'utf8mb4'

    OR

    COLLATION_NAME != 'utf8mb4_bin'

);

[Diego Figueroa]

Thank you for posting this. I would just like to point out that you have to quote 'jira' in the WHERE clause otherwise you get an error.

[Gonchik Tsymzhitov]

Hi!

Sorry, what exactly do you need?