Knowledgebase
MS SQL Server Collation
Posted by Mont Rothstein on 20 March 2017 08:37 AM

Problem When acquiring into an existing Folder with any letters are entered lower case they existing folder is not found. They have to be entered upper case.

Solution

If the database is MS SQL Server then the collation is incorrect. A case insensitive collation is required.

To change the collation of an existing MS SQL Server database: https://msdn.microsoft.com/en-us/library/ms175835(v=sql.110).aspx
 
 
The default value appears to be "SQL_Latin1_General_CP1_CI_AS", which will work with Foray Adams. The critical part is "CI" which stands for Case Insensitive.

 


Comments (0)