SQL Server Performance Forum – Threads Archive
Collation SettingsWhen 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… http://msdn2.microsoft.com/en-us/library/ms180175.aspx
SQL-Server-Performance.com 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 KBAhttp://support.microsoft.com/kb/322112 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.