LLI Wiki — My Digital Knowledge Base

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

Mastodon LLIMastodon SocialFosstodon