Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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

Edited
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'

);

2 answers

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.

0 votes

Hi!

Sorry, what exactly do you need?

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Jira Service Management

Security Advisory for Jira Service Management

On October 20, 2021, Atlassian published a security advisory for Jira Service Management. The full advisory is available at this link.  We've seen a number of questions already asking for...

242 views 1 2
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you