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?
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;
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.
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 ...
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