症状

Confluence does not start up when using MySQL database. One of the following errors is displayed:

• Detected tables with non-default character encoding.
• Detected tables with non-default collation.

原因

Confluence 5.2.4 added a check for tables with character encoding or collation setting that differs from the database default settings. Using non-default setting in a table can cause upgrade process to fail and leave the database in an inconsistent state.

ソリューション

Please see the How to Fix the Collation and Character Set of a MySQL Database manually knowledge base article and ensure that the database runs with unified character encoding and collation settings at all levels: database, table, and column.