Everything I Never Wanted to Know About Collation (14 minute video/podcast episode)

on July 16, 2020

I’m not an expert on collation in SQL Server, but there are a few important facts which I’ve had to learn the hard way. In this episode I share the basics, along with helpful resources to learn more.

One small localization correction: the default collation on a SQL Server install will be “the oldest available version that’s associated with each specific locale.” So if your Windows installation has a different localization than mine – I always use English (USA) – then you’ll see a different default collation than the one I discuss in the episode. The main point is still the same: it won’t be the recommended collation for *new* development.

Resources:

Prefer to listen on the go? Get this episode on iTunesplay the audio file, or find Dear SQL DBA in your favorite podcast app.