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 database collation referenced in the documentation throws a warning. How do i fix this?

My healthcheck fails with "The database collation 'utf8_bin' and table collation 'utf8_bin' are not supported by Jira".  

The link in that message eventually leads me to .  Those instructions tell me to "ALTER DATABASE yourDB CHARACTER SET utf8 COLLATE utf8_bin" which will set my database collation to 'utf8_bin' which is just what the error message is objecting to.


Which character sets and collation for databases and tables does Atlassian want for Mysql 5.7.26?

1 answer

1 accepted

1 vote
Answer accepted

@Bearcat M_ Şándor 


Hi Bearcat


which jira version are you using?

In case of jira 8 please take a look to

There you will need to use utf8mb4





Thank you Kurt!  That worked for the database.  If i create  and run the alter tables commands via the instructions in  it still complains that "The table collation: 'utf8_bin' is unsupported by Jira.", but i don't know where to determine what the correct table collation should be.


I'm using Jira 8.1.0.


Also, as an aside, do you know if multiple applications (jira, service desk etc.) can share the same database, or do i need to set up a separate database for each one? I asked this of sales, but they didn't understand the question.

I actually resolved this with tech support. It turns out that you want for both the database and the tables.

Like A_L likes this

may i know how do you fixed ?

Suggest an answer

Log in or Sign up to answer

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