日语下应该选哪个collation

[sunlightbj]

有Jap, Jap_90, Jap_unicode, 另外还有CS/CI, AS/AI, KS/KI, WS/WI

我看了MSDN,但还是不清楚,大家都选什么呢? 谢谢大家

我们用的SQL Server2005, 数据中Unicode和非Unicode都有

MSDN这一段也不是很明白,到底该如何设置,莫非Windows设置成日语就可以了?

If you have a mix of Unicode and non-Unicode columns in your database, you should primarily use Windows collations. Windows collations apply Unicode-based sorting rules to both Unicode and non-Unicode data. This means that SQL Server internally converts non-Unicode data to Unicode to perform comparison operations. This provides consistency across data types in SQL Server, and also provides developers with the ability to sort strings in their applications that use the same rules that SQL Server uses.

SQL collations, on the other hand, apply non-Unicode sorting rules to non-Unicode data, and Unicode sorting rules to Unicode data, by using a corresponding Windows collation for the Unicode data. This difference can cause inconsistent results for comparisons of the same characters. Therefore, if you have a mix of Unicode and non-Unicode columns in your database, they should all be defined by using Windows collations so that the same sorting rules are used across Unicode and non-Unicode data.

[fcuandy]

用 unicode 类的吧,通用.

我也不知道,乱说的,哈哈.

[-狙击手-]

Jap_unicode

[liangCK]

帮顶.

[sunlightbj]

那么CS,AS,KS,WS设置呢?

似乎有了Windows collation,就不需要SQL collation了,是这样吗?

[fcuandy]

不是.
设了windows时区,只不过SQL安装时会找个默认值,与windows时区对应.
还是可以设回来.