How to Fix the Collation and Character Set of a MySQL Database

Still need help?

The Atlassian Community is here for you.

Ask the community

In newer versions of Confluence, database requirements become more and more stringent. This is to ensure that users get the most consistent experiences when working with content, regardless of the content in their database. 

Collation in MySQL can be complicated because you can have a separate collation set at:

  1. The database level
  2. The table level
  3. The column level

Additionally, information inside a column may be encoded incorrectly as well - causing the data in that column to be displayed incorrectly.

If your MySQL database doesn't use the recommended collation and character sets, you can run these queries against your database to bring them into line with the Recommended Database Setup For MySQL.

Before Proceeding

Before proceeding, ensure that you:

  • Shut down Confluence
  • Complete a full database backup

You may also wish to apply these changes in a test environment before applying them to production.

Table of Contents



Last modified on Feb 19, 2016

Was this helpful?

Provide feedback about this article
Powered by Confluence and Scroll Viewport.