Detected tables with non-default collation

[Pieter-Jan Vanhoutte]

My Confluence throws error at startup saying Detected tables with non-default collation.
My admin set default collation to utf8_bin for all table for confluence database.
He also followed your KB https://confluence.atlassian.com/kb/how-to-fix-the-collation-and-character-set-of-a-mysql-database-744326173.html

But no luck.

[Shannon S]

Hi Pieter-Jan,

It won't just be the tables you need to check. Per the article you linked, you need to also check:

• MySQL Collation Repair: Database Level Changes
• MySQL Collation Repair: Table Level Changes
• MySQL Collation Repair: Column Level Changes
• MySQL Collation Repair: Column Level Encoding Issues
• MySQL Collation Repair: Case Study - Repairing a Production Database

If it's a fresh install, then he could even destroy the database and create it again using this article:

• Database Setup for MySQL

Lastly, you can have a look at the error logs itself and see what the error is actually saying in case it leads to the specific part that has the wrong collation.

Let us know if you have any trouble.

Regards,

Shannon