Getting Error UTF8

Bill Hoffman June 13, 2022

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?

 

 

 

2 answers

1 vote
Robert Wen_ReleaseTEAM_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
June 13, 2022

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.

0 votes
Bill Hoffman June 13, 2022

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

Robert Wen_ReleaseTEAM_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
June 13, 2022

Yes.  The command would be something like this:

ALTER DATABASE <yourDB> CHARACTER SET utf8mb4 COLLATE utf8mb4_bin
Bill Hoffman June 13, 2022

OK Thanks I will try this

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
SERVER
VERSION
8.22.3
TAGS
AUG Leaders

Atlassian Community Events