The wonderful world of collations, encodings and text storage
summary
Explains characters, encodings, collations, sort orders, diacritics and code pages as they relate to text storage in databases, using SQL Server/Azure context. Describes what each concept is and how they interact so developers and DBAs can handle text data and avoid encoding/collation problems.
AI-written summary · about
chapters (7)
- 0:00Start
- 2:03Basic building blocks of text
- 4:43Collations
- 16:30Data types
- 28:11Code point composition
- 31:28Unicode equivalence
- 37:23Unicode Security Issues
related talks
01h 02mThere's No Such Thing as Plain Text
20mStoring strings in SQL Server and Azure SQL DB
15mCharacter set and collation basics
52mCollations from A to Z
48mMS SQL New functions, syntaxes, tips & tricks
29mLocalization on PostgreSQL
27mWorking with Multilingual Data in SQL Databases through Erlang
52mACID in SQL Server: what it is, how it works, and how to live more adventurously.