LLI Wiki — My Digital Knowledge Base

SQL Server: contained database collation and collation conflicts

The fixed Latin1_General_100_CI_AS_WS_KS_SC collation of contained databases and how to avoid conflicts.

A contained database uses a fixed catalog collation: Latin1_General_100_CI_AS_WS_KS_SC. If the instance collation differs, collation conflict errors can appear, for example when comparing columns of the contained database with temporary tables (tempdb).

Latin1_General_100_CI_AS_WS_KS_SC

To avoid these errors, use this collation in the affected queries or column definitions (COLLATE clause), or align the objects involved with it.

References:

Mastodon LLIMastodon SocialFosstodon