Collate Name Notification For Free

Latin1 makes the server treat strings using charset latin 1, basically ascii. CP1 stands for Code Page 1252. CI case insensitive comparisons so 'ABC' would equal 'abc'

According the SQL Server Books Online, the characters included in range searches depend on the sorting rules of the collation. Collation Latin1GeneralCSAS uses dictionary order so both upper and lower case characters of the specified range are included.

The collate clause is used for case sensitive and case insensitive searches in the columns of the SQL server. There are two types of collate clause present: SQLLatin1GeneralCP1CSAS for case sensitive. SQLLatin1GeneralCP1CIAS for case insensitive.

You can change the collation of any new objects that are created in a user database by using the COLLATE clause of the ALTER DATABASE statement. This statement does not change the collation of the columns in any existing user-defined tables. These can be changed by using the COLLATE clause of ALTER TABLE.

The SQLLatin1GeneralCP1CIAS collation is a SQL collation and the rules around sorting data for unicode and non-unicode data are different. The Latin1GeneralCIAS collation is a Windows collation and the rules around sorting unicode and non-unicode data are the same.

However here are the settings we typically recommend: Set the default collation to SQLLatin1GeneralCP1CIAS. Ensure that you have SQL Server running in Case Insensitive mode. We use NCHAR, NVARCHAR string types so all data is unicode, so no character set is specified.

Codepage Specifies a one- to four-digit number that identifies the code page used by the collation. CP1 specifies code page 1252, for all other code pages the complete code page number is specified. For example, CP1251 specifies code page 1251 and CP850 specifies code page 850.

SQL Server installation configuration sets the default collation for the created instance (Latin1GeneralCIAI). New databases will be configured with the default collation of the SQL Server. Users can change the collation settings at the database level but not at the SQL Server level.

You can use the COLLATE clause to apply a character expression to a certain collation. Character literals and variables are assigned the default collation of the current database. Column references are assigned the definition collation of the column.

MSDN states COLLATE DATABASEDEFAULT clause casts the collation of an expression, column definition, or database definition to inherit the collation of the "current database". To complement MSDN, the "current database" is the context of the database where the query is executed.