how to Fix the Collation

[Casper]

hi, may i know how to fix the error below? 

i did follow How to Fix the Collation and Character Set of a MySQL Database but still getting the same error. 

[Casper · Accepted solution]

may i know any one can help  ? 

[Jack Nolddor _Sweet Bananas_]

Have you check the today's article?
https://community.atlassian.com/t5/Jira-articles/Unable-to-start-Jira-with-quot-The-database-setup-is-not/ba-p/1202992

Not sure if you can find any extra information there.

Regards

[Jack Nolddor _Sweet Bananas_]

Hi Casper,
I believe you have to fix your table collation by using the following SQL:

SELECT CONCAT('ALTER TABLE ',  table_name, ' CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;')
FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C
WHERE C.collation_name = T.table_collation
AND T.table_schema = 'yourDB'
AND
(
    C.CHARACTER_SET_NAME != 'utf8mb4'
    OR
    C.COLLATION_NAME != 'utf8mb4_bin'
);

As mention in the Changing Table Collation section. Then, restart the application.

Tell us if works for you.
Regards.

[Casper]

Hi Jack Nolddor,

Thanks for the reply.

I did that before as i following this  How to Fix the Collation and Character Set of a MySQL Database, still having the error.

May i know below is correct or wrong?