SQL Server: catalog collation of contained databases (Latin1_General_100_CI_AS_KS_WS_SC)
Name and meaning of the default catalog collation of SQL Server contained databases.
SQL Server contained databases use the following catalog collation for their metadata. This memo helps you find it and understand its name (the case of the name does not matter to SQL Server).
Latin1_General_100_CI_AS_KS_WS_SC
Meaning
| Part | Meaning |
|---|---|
Latin1_General_100 |
General Latin1 Windows collation, version 100 (SQL Server 2008 and later) |
CI |
Case-insensitive |
AS |
Accent-sensitive |
KS |
Kana-sensitive |
WS |
Width-sensitive |
SC |
Supplementary character support (UTF-16 surrogate pairs) |
Notes
- The order of the suffixes in the name (
AS_WS_KSorAS_KS_WS) does not change the collation. - Full list of supported collations: Full list of collations supported in SQL Server 2017.