SQL Server 2008-排序规则类型之间的差异 [英] Sql Server 2008 - Difference between collation types

问题描述

我正在安装新的SQL Server 2008服务器，但是在获取有关不同归类的任何可用信息时遇到一些问题。我已经搜索了SQL Server BOL，并用google搜索了答案，但似乎找不到任何可用的信息。

I'm installing a new SQL Server 2008 server and are having some problems getting any usable information regarding different collations. I have searched SQL Server BOL and google'ed for an answer but can't seem to be able to find any usable information.

1. 什么是Windows排序规则 Finnish_Swedish_100 和$code> Finnish_Swedish 之间的区别？

1. What is the difference between the Windows Collation "Finnish_Swedish_100" and "Finnish_Swedish"?

我认为 _ 100 -version是SQL Server 2008中的更新排序规则，但是如果是这种情况，与旧版本相比有什么变化？

I suppose that the "_100"-version is a updated collation in SQL Server 2008, but what things have changed from the older version if that is the case?

启用区分重音 通常是一件好事？我知道这取决于任务以及所有其他事情，但是是否有任何著名的利弊考虑？

Is it usually a good thing to have "Accent-sensitive" enabled? I know that it depends on the task and all that, but is there any well-known pros and cons to consider?

c $ c>二进制 和二进制代码点 参数，在哪种情况下应启用这些功能？

The "Binary" and "Binary-code point" parameters, in which cases should theese be enabled?

推荐答案

字母ÅÄÖ/åäö不会与A和O混淆只需将排序规则设置为AI（不区分重音）即可。但是，对于â和其他不属于瑞典字母的组合，都是如此。

The letters ÅÄÖ/åäö do not mix up with A and O just by setting the collation to AI (Accent Insensitive). That is however true for â and other "combinations" not part of the Swedish alphabet as individual letters. â will mix or not mix depending of the setting in question.

由于我有很多旧数据库仍需要与之通信，也使用链接服务器，因此我选择了混合或不混合FINNISH _SWEDISH _CI _AS现在我正在安装SQL2008。 Windows排序规则首次出现在SQL Server中时，这是FINNISH _SWEDISH的默认设置。

Since I have a lot of old databases I still need to communicate with, also using linked servers, I chose FINNISH _SWEDISH _CI _AS now that I'm installing SQL2008. That was the default setting for FINNISH _SWEDISH when the Windows collations first appeared in SQL Server.

这篇关于SQL Server 2008-排序规则类型之间的差异的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！