Database collation is incorrect after update from 4.2.0 to 5.10.0

[Fernando Sorensen]

After updating Confluence from 4.2 to 5.10 (in order to test migration to cloud) we got this error:

Database collation is incorrect, it must be set to 'SQL_Latin1_General_CP1_CS_AS'

Of course 4.2 version was working fine with no isuues.

[Nic Brough -Adaptavist- · Accepted solution]

You will need to change the collation on the database server.

Depending on your database, you may need to dump (meaning backup) and recreate your confluence database after changing the collation, or just make the change and let it reprocess.  Ideally, that change should be as future-proof as possible.

Without knowing what your database server is, there's not a lot more we can tell you.

[Fernando Sorensen]

It's a MS SQL Server 2017

[Nic Brough -Adaptavist-]

Ok, you'll need to follow the guide in https://docs.microsoft.com/en-us/sql/relational-databases/collations/set-or-change-the-server-collation?view=sql-server-ver15

[Fernando Sorensen]

Thank you very much.