sql - Kanatype Sensitive KS 和宽度敏感是什么意思

Question

创建新数据库时，我必须设置排序规则类型或设置其默认值....很好。

但实际上我需要知道 Kanatype Sensitive(KS) 和宽度敏感是什么意思，我知道例如区分大小写意味着字母对大写和小写敏感，那么 Kanatype Sensitive 和宽度敏感呢？

Answer 1

两者都与排序有关，通常您不会选择这两个选项。这是微软的描述礼貌。

假名敏感

Distinguishes between the two types of Japanese kana characters: Hiragana and Katakana.

If this option is not selected, SQL Server considers Hiragana and Katakana characters to be equal for sorting purposes

宽度敏感

Distinguishes between a single-byte character and the same character when represented as a double-byte character.

If this option is not selected, SQL Server considers the single-byte and double-byte representation of the same character to be identical for sorting purposes.