Database Server Collation and Database collation

database
mssql

(DBNull) #1

I am trying to setup an MS SQL Server database. I noticed one of the requirements is to make sure "Collation is set to case-sensitive and accent-sensitive:
Collation can be set on the database server as well as on the database itself, my question is that does the collation set on the database server and on the database be the same as stipulated in the requirement ? My version of SonarQube to use with the database is SonarQube 6.7.5, SQL Server could be 2012, 2014 or 2016.
Please assist.


(Simon Brandhof) #2

Hi,

Only the collation of the SonarQube schema needs to to follow the contraints.

Regards