If you have any non-ASCII characters wouldn’t the C collation be very surprising... | Hacker News

Hacker News new | past | comments | ask | show | jobs | submit

login

jtc331 on Jan 19, 2022 | parent | context | favorite | on: In MySQL, use “utf8mb4” instead of “utf8” (2016)

If you have any non-ASCII characters wouldn’t the C collation be very surprising? I’m having a hard time seeing how the C collation is a sensible default for UTF encoded text. If you want to limit to ASCII the why are you using UTF?

cakoose on Jan 22, 2022 [–]

The C collation applied to UTF-8 just orders everything by Unicode codepoint.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact