Kies uw schermresolutie: Auto adjust 800x600 1024x768

Microsoft 365

Tips & Trucs

Windows 10

Tips & Trucs

Windows 8

Tips & Trucs

Windows 7

Tips & Trucs

Windows Vista

Tips & Trucs

Windows XP

Tips & Trucs

Windows 2016 Server

Tips & Trucs

Windows 2012 Server

Tips & Trucs

Windows 2011 Server

Tips & Trucs

Windows 2008 Server

Tips & Trucs

Windows 2003 Server

Tips & Trucs

VMware

Tips & Trucs
Windows SQL Collation suffixes Afdrukken E-mail
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.