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 https://confluence.atlassian.com/kb/how-to-fix-the-collation-and-character-set-of-a-mysql-database-744326173.html .  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 https://confluence.atlassian.com/adminjiraserver/connecting-jira-applications-to-mysql-5-7-966063305.html?_ga=2.71942421.760743069.1558553405-1920476288.1555958504

There you will need to use utf8mb4

CREATE DATABASE jiradb CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;

 

Cheers

Kurt

Thank you Kurt!  That worked for the database.  If i create  and run the alter tables commands via the instructions in https://confluence.atlassian.com/kb/how-to-fix-the-collation-and-character-set-of-a-mysql-database-744326173.html  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 showcase
Posted in Jira

Demo Den Ep. 7: New Jira Cloud Reports

Learn how to use two new reports for next-gen projects in Jira Cloud:  Cumulative flow diagram and Sprint burndown chart. Ivan Teong, Product Manager, Jira Software, demos the Cumulative ...

229 views 1 2
Join discussion

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