Hacker News new | ask | show | jobs
by GoblinSlayer 613 days ago
>MySQL is easier for developers

Except that search doesn't work, because all text is in latin1 encoding.

3 comments

While obviously I prefer Unicode, latin-1 is perfectly acceptable for most use cases in Western cultures.

What part of searching have you found to not work well using it?

The catch is that PHP backend passes strings in utf8.
This was never true if you know what you're doing, and hasn't been true since 2018 even if you don't.
Either latin1 or that absolutely horrible max-three-byte utf8 encoding that used to be the only available option for utf8.