MS SQL Server Collation

Owned by Scott Friend
Apr 30, 2019

Problem

When acquiring into an existing Folder where any letters are entered lower case the 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.



© 2023 Foray, LLC - All Rights Reserved