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

,

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.

Original post (opens in new tab)
View comments in original post (opens in new tab)

Rate

Share

Share

Rate