nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Character Set and Collation problem in Confluence After Space Import

Shirley He

I am trying to merge two confluence instances together. I was successful in importing a couple of spaces from the source instance into the target instance, however at some point in time I started getting warnings about the Character Set and Collation of the target confluence instance.

I checked the source instance afterwards and found that its character set and collation appeared to be different from the target instance. At the moment I just want to amend the error in the target instance.

I've tried changing the character set and collation in the database with MySQL but this just resulted in Confluence not being able to restart.

Any tips as to what I can do?

Accepted answers

Diego_88dj6o

Hello there Shirley!
Could you clarify a few points for us:

What collation is used in the original database?

What collation is used in the destination?

What version is the original Confluence instance?

What version is the destination Confluence instance?

If the destination database is a new one without any active content, you could take a look here and check if the database is compliant with Confluence requirements:

- Database Setup for PostgreSQL

You can check details about variables set for your database with the following command:

SHOW VARIABLES

If possible, share this information with us. Keep in mind to avoid sharing sensitive information, like passwords, usernames or any other kind of data that should not be public.

Looking forward to your findings Shirley!

All comments

Diego_88dj6o

Hello there Shirley!
Could you clarify a few points for us:

What collation is used in the original database?

What collation is used in the destination?

What version is the original Confluence instance?

What version is the destination Confluence instance?

If the destination database is a new one without any active content, you could take a look here and check if the database is compliant with Confluence requirements:

- Database Setup for PostgreSQL

You can check details about variables set for your database with the following command:

SHOW VARIABLES

If possible, share this information with us. Keep in mind to avoid sharing sensitive information, like passwords, usernames or any other kind of data that should not be public.

Looking forward to your findings Shirley!

Shirley He

The collation used in the original database (postgresql) is: en_GB.UTF8
1. The character set used in the original database (postgresql) is: UTF8
The collation used in the destination database (mysql) is: latin1_swedish_ci
1. The character set used in the destination database (mysql) is latin1
The version of the original Confluence instance is: 6.6.0
The version of the destination Confluence instance is: 6.7.2

The destination database is not a new one. We have been using it for quite a while.

When we change the collation of the tables back to latin1_swedish_ci, confluence is able to start up successfully, otherwise it cannot start up and gives us an error stating there are mismatched collations in the database.

Diego_88dj6o

Hi again Shirley! Currently, your destination has an incorrect collation and must be fixed. Incorrect database collation can cause a wide array of issues with Confluence. The following article can guide you through on how to fix it:

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

After this fix, the database Collation should be compliant and good to go!

Please, if you have questions or is not sure on how to proceed with any points exposed there, come clarify it with us! The process can be quite delicate depending on how critical this instance is for your business.

Remember:

Always backup your database before applying changes to it

As a good measure, you can also backup <confluence-home> and <confluence-install> folders

Shirley He

Hello Diego,

I think that page and its associated links were the first things we found and tried. We changed database, table, column, etc. collation and character set to what was suggested (utf8_bin and utf8) but it resulted in Confluence not being able to start up.

We managed to fix it once, by changing the settings back to what was originally there, but now the same fix isn't working again. I think we might have to restore a previous backed up version of Confluence to get it working again, however we'll still have the problem of figuring out how to properly change the collation and character set to something compatible with Confluence before we can try importing again.

Regards,

Shirley

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

collation

confluence

import