14

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

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Chintan Shah
  • 373
  • 1
  • 2
  • 16

1 Answers1

17

This question and answers provides details on these collations and how they relate:

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).

Kissaki
  • 8,810
  • 5
  • 40
  • 42
Ian Preston
  • 38,816
  • 8
  • 95
  • 92