Hi Ernst!
As described on one of our documents on best practices for MySQL connection within Confluence, as you can see here, we recommend setting up the database using case-sensitive collation. Using any other collation or charset is unsupported and may lead to problems with indexes or data storage.
Cheers!
--
Joao
Hi thanks for your answer. Confluence is now installed on a case insensitive server, is there a way to convert the database to case sensitive?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I have another MySQL server but when I create the database, it creates it automatically with utf_general_ci collation. Is this OK? I don't have access to the command line on this server to create the database.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
never mind, i have created a new database, run a query via phpmyadmin to set the correct collation and run the confluence setup wizard again. ALTER DATABASE confluence CHARACTER SET utf8 COLLATE utf8_bin
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.