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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.