MS SQL Server Collation

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

Collation Name: https://msdn.microsoft.com/en-us/library/ms188046(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.

MS SQL Server Collation

[data-colorid=qbczyqaslx]{color:#333333} html[data-color-mode=dark] [data-colorid=qbczyqaslx]{color:#cccccc}Problem

Solution

Related articles

Problem