Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

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_Cprime_
Community Champion
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_Cprime_
Community Champion
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