Why is MySQL's default collation latin1_swedish_ci?

The bloke who wrote it was co-head of a Swedish company.

Possibly for similar reasons, Microsoft SQL Server's default language us_english.


latin1_swedish_ci is a single byte character set, unlike utf8_general_ci.

Compared to latin1_general_ci it has support for a variety of extra characters used in European languages. So it’s a best choice if you don’t know what language you will be using, if you are constrained to use only single byte character sets.