Collation Settings | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Collation Settings

When creating databases we have the collation setting set to "COLLATE SQL_Latin1_General_CP1_CI_AS". We recently had a customer request to use Latin1_General_CI_AS. I have not been able to find much documentation regarding these settting and their differences. Can anyone give me any information as to their differences and where there might be some good documentation? Many thanks, Tyler
Check the BOL topic "SQL Collation Name" they two different sort orders…
Moderator All postings are provided “AS IS” with no warranties for accuracy.

Have you seen any issues with appilcation lately, with that collation difference?
See this KBA and I don’t see any issue between those 2 collation settings in data managebility unless you are using UNICODE data. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.