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.
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.
It's a MS SQL Server 2017
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
Thank you very much.
It looks like you're new here. Sign in or register to get started.
