Has anyone succesfully upgrade Confluence from version 6.7.1 to 6.15.2?

[Rayaldo_Salters]

I got an error message stating that
" Database: The database collation 'English_United States.1252 is not supported by Confluence. You need to use 'utf-8'

and most of my data is no longer there.

[Tilo Schneider]

Please have a look at this articles (depending on your database)

• https://confluence.atlassian.com/confkb/how-to-fix-the-collation-of-a-postgres-confluence-database-966676071.html
• https://confluence.atlassian.com/confkb/how-to-fix-the-collation-of-a-microsoft-sql-server-confluence-database-687216725.html
• https://confluence.atlassian.com/confkb/how-to-fix-the-collation-and-character-set-of-a-mysql-database-670958160.html

Do you still have a recent backup so that you can make the collation change before the upgrade?

[Tilo Schneider]

Hi Rayaldo,

we don't have this upgrade done in our environment yet. But a few questions from my side. 

• Which database do you use?
• What was the collation before you updated the environment?

[robert_w1_smith]

I have this exact same problem.  I have UTF8 encoding, but the collation types are English_United States.1252.  My Windows Postgres 9.4 install won't accept any other collation types complaining about an incorrect locale.  Encoding is already UTF8.  The confluence articles referenced below by Tilo did not help me.

postgres=# create collation en_US (LOCALE='en_US.utf-8');
ERROR: could not create locale "en_US.utf-8": No error

Attempted to reinitialize the DB:

initdb: invalid locale name "en_US.UTF-8"

My plan now is to move to Linux hoping that solves the issue.

[Rayaldo_Salters]

Hi Tilo, 

I am way late on my reply but I was able to upgrade it on my second attempt.

Thank you.