Running Jira version 8.22.3 on MYSQL Version 8.0.29
I am receiving an error message
"The database collation 'utf8_bin' and table collation 'utf8_bin' are not supported by Jira"
Yet all documentation regarding this instructs you to set this exact UTF8_Bin for Jira
See Link
What gives it utf8_bin supported on Jira or not?
Hello @Bill Hoffman ! Welcome to the Atlassian Community!
According to the link you supplied, the version of Jira you're running supports utf8mb4 and not utf8_bin. It's erroring because you're trying to set a collation that isn't supported anymore.
So can I use the information in the Link to update to utf8mb4 using the same Queries?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Yes. The command would be something like this:
ALTER DATABASE <yourDB> CHARACTER SET utf8mb4 COLLATE utf8mb4_bin
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.