Voorbeelden van Windows Collations
Elke Windows collation wordt gecombineerd door een reeks van achtervoegsels die definiëren de case, accent, width, of kana gevoeligheid. De volgende voorbeelden beschrijven sorteervolgorde gedrag voor verschillende combinaties van achtervoegsels.
| Windows collation suffix | Sorteer volgorde omschrijving |
|---|---|
|
_BIN1 |
Binary sort. |
|
_BIN21 |
Binary-code point sort order, new in SQL Server 2005. |
|
_CI_AI |
Case-insensitive, accent-insensitive, kana-insensitive, width-insensitive. |
|
_CI_AI_KS |
Case-insensitive, accent-insensitive, kana-sensitive, width-insensitive |
|
_CI_AI_KS_WS |
Case-insensitive, accent-insensitive, kana-sensitive, width-sensitive |
|
_CI_AI_WS |
Case-insensitive, accent-insensitive, kana-insensitive, width-sensitive |
|
_CI_AS |
Case-insensitive, accent-sensitive, kana-insensitive, width-insensitive |
|
_CI_AS_KS |
Case-insensitive, accent-sensitive, kana-sensitive, width-insensitive |
|
_CI_AS_KS_WS |
Case-insensitive, accent-sensitive, kana-sensitive, width-sensitive |
|
_CI_AS_WS |
Case-insensitive, accent-sensitive, kana-insensitive, width-sensitive |
|
_CS_AI |
Case-sensitive, accent-insensitive, kana-insensitive, width-insensitive |
|
_CS_AI_KS |
Case-sensitive, accent-insensitive, kana-sensitive, width-insensitive |
|
_CS_AI_KS_WS |
Case-sensitive, accent-insensitive, kana-sensitive, width-sensitive |
|
_CS_AI_WS |
Case-sensitive, accent-insensitive, kana-insensitive, width-sensitive |
|
_CS_AS |
Case-sensitive, accent-sensitive, kana-insensitive, width-insensitive |
|
_CS_AS_KS |
Case-sensitive, accent-sensitive, kana-sensitive, width-insensitive |
|
_CS_AS_KS_WS |
Case-sensitive, accent-sensitive, kana-sensitive, width-sensitive |
|
_CS_AS_WS |
Case-sensitive, accent-sensitive, kana-insensitive, width-sensitive |
1 If BIN or Binary-code point is selected, the Case-sensitive, Accent-sensitive, Kana-sensitive, and Width-sensitive options are not available.