Getting Error UTF8

[Bill Hoffman]

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

https://confluence.atlassian.com/kb/how-to-fix-the-collation-and-character-set-of-a-mysql-database-744326173.html

What gives it utf8_bin supported on Jira or not?

[Robert Wen]

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.

[Bill Hoffman]

So can I use the information in the Link to update to utf8mb4 using the same Queries?

[Robert Wen]

Yes.  The command would be something like this:

ALTER DATABASE <yourDB> CHARACTER SET utf8mb4 COLLATE utf8mb4_bin

[Bill Hoffman]

OK Thanks I will try this