Collation Info (Concepts)

Collations Info

Home Concepts Answers Reference Microsoft Connect Contact

collation, encoding, code page, locale, sorting, comparison, LCID, T-SQL, TSQL, SQL Server

— Concepts —

SQL Server
Constants SQL Server Collation Name Windows Collation Name Collation Precedence Collation and Unicode Support Set or Change the Server Collation Set or Change the Database Collation Rebuild System Databases Contained Database Collations UTF-16 Support in SQL Server Native Client 11.0 ODBC Driver Behavior Change When Handling Character Conversions

Blog Posts

Impact on Indexes When Mixing VARCHAR and NVARCHAR Types
No, Binary Collations are not Case-Sensitive
All New Collations in SQL Server 2017 Implicitly Support Supplementary Characters
Which Collation is Used to Convert NVARCHAR to VARCHAR in a WHERE Condition? (Part A of 2: “Duck”)
Which Collation is Used to Convert NVARCHAR to VARCHAR in a WHERE Condition? (Part B of 2: “Rabbit”)
The Uni-Code: The Search for the True List of Valid Characters for T-SQL Regular Identifiers, Part 1
The Uni-Code: The Search for the True List of Valid Characters for T-SQL Regular Identifiers, Part 2
What’s in a Name?: Inside the Wacky World of T-SQL Identifiers
The Uni-Code: The Search for the True List of Valid Characters for T-SQL Identifiers, Part 3 of 2 (Delimited Identifiers)
Changing the Collation of the Instance, the Databases, and All Columns in All User Databases: What Could Possibly Go Wrong?
Native UTF-8 Support in SQL Server 2019: Savior or False Prophet?
Beware! Beware of Unintended Changes When Altering Columns!
What Does the Undocumented UNCOMPRESS Function Do?
Differences Between the Various Binary Collations (Cultures, Versions, and BIN vs BIN2)
Uppercase All String Columns (and in a Single Query!)
SSMS Tip #3: Easily Access/Research ALL Unicode Characters (Yes, Including Emojis 😸)
Unicode Escape Sequences Across Various Languages and Platforms (including Supplementary Characters)
How Many Bytes Per Character in SQL Server: a Completely Complete Guide
SSMS: Prevent Copy and Paste of Text in “Messages” tab (Cruel Joke #2)
SQL Server Collations: What does “CP1” mean in “SQL_Latin1_General_CP1_CI_AS”?
Is the [sysname] SQL Server System Data Type Alias Name Case-Insensitive?

Windows / .NET
Double-Byte Character Sets in Windows Unicode Compatibility Issues in Mixed Environments Unicode Data Conversion The Code-Page Model Character Encoding in .NET Using Unicode Normalization to Represent Strings Best Practices for Using Strings in .NET Comparing Strings in .NET