SQL_Latin1_General_CP1_CS_AS和Latin1_General_CS_AS [英] SQL_Latin1_General_CP1_CS_AS vs Latin1_General_CS_AS

问题描述

SQL Server中的 SQL_Latin1_General_CP1_CS_AS 和 Latin1_General_CS_AS 归类之间的确切区别是什么？

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

推荐答案

我会将其添加为评论，但我的信誉不高。

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:

可以将SQL Server SQL_Latin1_General_CP1_CI_AS安全地转换为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.

我唯一要添加的是 SQL_Latin1_General_CP1_CS_AS 是 English（美国）语言环境，而 Latin1_General_CS_AS 是任何其他英语语言环境（例如英语（英国））的默认排序规则。

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

这篇关于SQL_Latin1_General_CP1_CS_AS和Latin1_General_CS_AS的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！