SQL_Latin1_General_CP1_CS_AS vs Latin1_General_CS_AS

sql-server collation
Chintan Shah picture Chintan Shah · Mar 14, 2012 · Viewed 22.9k times · Source

What are the exact differences between the SQL_Latin1_General_CP1_CS_AS and Latin1_General_CS_AS collations in SQL Server?

Answer

Ian Preston picture Ian Preston · Mar 14, 2012

I'd add this as a comment, but I don't have enough reputation.

Anyway, see this question for details on these collations and how they relate:

Can SQL Server SQL_Latin1_General_CP1_CI_AS be safely converted to Latin1_General_CI_AS?

To avoid hijacking that answer entirely, the only real difference is the sort order for some characters differs between the two collations. Character representation does not appear to differ.

The only thing I would add is that SQL_Latin1_General_CP1_CS_AS is the default collation for the English (United States) locale, and Latin1_General_CS_AS is the default collation for any other English locale, such as English (United Kingdom).

Related questions

What does 'COLLATE SQL_Latin1_General_CP1_CI_AS' do?

I have an SQL query to create the database in SQLServer as given below: create database yourdb on ( name = 'yourdb_dat', filename = 'c:\program files\microsoft sql server\mssql.1\mssql\data\yourdbdat.mdf', size = 25mb, maxsize = 1500mb, filegrowth = 10mb ) log …

Read More
SQL Server default character encoding

By default - what is the character encoding set for a database in Microsoft SQL Server? How can I see the current character encoding in SQL Server?

Read More
Cannot Resolve Collation Conflict

I have moved one of our databases (DB1) from SQL Server 2008 to 2012 and when I run the stored procedures I get the following error Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_…

Read More