SQLServer DB is using a collation which is not case sensitive
Symptoms
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'Diagnosis
Run the following query to verify the default collation:
SELECT SERVERPROPERTY('Collation');Cause
The incorrect default collation is being used by the SQL Server.
Resolution
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.
Last modified on Jul 31, 2018
Powered by Confluence and Scroll Viewport.