SQLServer DB is using a collation which is not case sensitive
When trying to migrate the HSQLDB to SQL Server the following message can be seen on the page:
The database is not using case-sensitive Unicode. FishEye and Crucible require that the database is case-sensitive and uses a UTF8 encoding to support internalization.
, or before Fisheye 3.10
The database is not using Unicode. FishEye and Crucible require that the database uses a UTF8 encoding to support internalization.
From the logs:
2012-07-26 10:22:31,599 ERROR [btpool0-83 ] fisheye.app DBType-isSqlServerCollationCaseSensitive - SQLServer DB is using a collation which is not case sensitive: 'SQL_Latin1_General_CP1_CI_AS'
Run the following query to verify the default collation:
The incorrect default collation is being used by the SQL Server.
Changing the default collation for the SQL Server might impact the other databases running on it. Proceed with care and backup all data before applying any changes.
- Shutdown Fisheye.
- Set the default database collation in SQL Server to
Latin1_General_CS_ASas indicated in our documentation.
- Start Fisheye.