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.