Why is MySQL's default collation latin1_swedish_ci?

mysql collation
Alan picture Alan · Jul 21, 2011 · Viewed 78.2k times · Source

What is the reasoning behind setting latin1_swedish_ci as the compiled default when other options seem much more reasonable, like latin1_general_ci or utf8_general_ci?

Answer

gbn picture gbn · Jul 21, 2011

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

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

Related questions

How do I see what character set a MySQL database / table / column is?

What is the (default) charset for: MySQL database MySQL table MySQL column

Read More
What is the best collation to use for MySQL with PHP?

I'm wondering if there is a "best" choice for collation in MySQL for a general website where you aren't 100% sure of what will be entered? I understand that all the encodings should be the same, such as MySQL, Apache, the …

Read More
What's the difference between utf8_general_ci and utf8_unicode_ci?

Between utf8_general_ci and utf8_unicode_ci, are there any differences in terms of performance?

Read More