As a result of errors from the Confluence logs warning of incorrect character set and/or collation, or as a result of recommendations from Atlassian Support, administrators may want some guidance on how to switch to utf8 character set with utf8_bin collation for the Confluence database at the database, table, and column levels.

Resolution

Please refer to this step-by-step guide on how to change the character set and collation at all levels: How to Fix the Collation and Character Set of a MySQL Database