The database collation referenced in the documentation throws a warning. How do i fix this?

[Bearcat M_ Şándor]

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?

[Kurt Klinner · Accepted solution]

@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

[Bearcat M_ Şándor]

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.

[Bearcat M_ Şándor]

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

[Casper]

may i know how do you fixed ?