![Dear SQL DBA artwork](https://is1-ssl.mzstatic.com/image/thumb/Podcasts113/v4/59/ab/d4/59abd4b9-e5da-2b36-9150-b2f2f8027ed0/mza_6525806208753554299.png/100x100bb.jpg)
Everything I Never Wanted to Know about Collation
Dear SQL DBA
English - July 16, 2020 11:29 - 13 minutes - 19 MB - ★★★★★ - 27 ratingsTechnology Education How To dba databases sqlserver sqlworkbooks Homepage Download Apple Podcasts Google Podcasts Overcast Castro Pocket Casts RSS feed
Previous Episode: The Manager's Guide to Git Training for DBAs
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 (which are generally English USA), then you'll see a different default collation -- but it still won't be the recommended collation for *new* development.