I was wondering why MySQL defaults to the latin1_swedish_ci collation and fell down a little bit of a rabbit hole, some of which I will now share with you.

The main author of the original version of the open source MySQL database is Michael "Monty" Widenius. Monty was born in Finland and co-founded MySQL AB (roughly the Swedish equivalent of "MySQL Ltd."), a Swedish company, in 1995.

Swedish and Finnish share the latin1_swedish_ci collation anyway (though it seems there is some disagreement on whether this is how things should be on both sides), and as such the default was set and hasn't changed to this day.


Monty's first daughter is named "My", and MySQL is named for her.


Monty also has a son, Max, and a second daughter - Maria

Sign in to participate in the conversation

The Fourth Dev Mastodon server.