News for hackers. Stuff that matters.

A comment on Why Uber Engineering Switched from Postgres to MySQL (2016). Parent comment

Re:Why Uber Engineering Switched from Postgres to MySQL (2016) by vinger on Saturday February 27, 2021 @09:33AM (#26285072)
utf8mb3 isn't a broken subset. It includes characters in the basic multilingual plane which is fine for 99% of cases.

uft8mb4 uses more bytes than necessary for most. You get 255 varchar limits with uft8mb3, I think you only get 192 characters with uft8mb4.

[ Parent | on HN ]
Re:Why Uber Engineering Switched from Postgres to MySQL (2016) by Alexendoo on Saturday February 27, 2021 @10:00AM (#26285240)
uft8mb4 does not use more bytes than utf8mb3, for anything representable by utf8mb3 the size in uft8mb4 is identical. Anything that would be 4 bytes in uft8mb4 is not able to be stored in utf8mb3

utf8mb3 is definitely a broken subset, it's deprecated at the very least

[ Parent | on HN ]