Think you understand computers? Which of the following is true:

1. ‘:' < ‘;’
2. ‘:’ > ‘;'

Correct answer: it depends! In a fresh install of MySQL, ‘:' < ‘;’. In Postgres, ‘:’ > ‘;'.

Follow my descent into madness (and Unicode collation) to find out why...



· Mastodon Twitter Crossposter · 1 · 1 · 1

@ennolenze Back in the days, MPlayer had a segfault, when an 'I' appeared within subtitles, but only with a TR locale. The reason being that MPlayer looked at the lower case character which for 'I' becomes 'ı' (notice the missing i-dot), which is outside the ASCII or even Latin-1 range. Took some time to figure that one out.

Sign in to participate in the conversation

Server run by the main developers of the project 🐘 It is not focused on any particular niche interest - everyone is welcome as long as you follow our code of conduct!