In MySQL, don’t use “utf8”, use “utf8mb4” (2016)

Re:In MySQL, don’t use “utf8”, use “utf8mb4” (2016) by cdevnull on Thursday June 14, 2018 @10:55AM (#17312178)

I use utf8 for "normal" field like name, address, etc.. (don't want smiley as first name). And use utf8mb4 for comment for example.

But I need filter/validate each inputs (and refuse when there is 4 bytes characters).

[ Parent | on HN ]

Re:In MySQL, don’t use “utf8”, use “utf8mb4” (2016) by khaled on Thursday June 14, 2018 @11:52AM (#17312551)

There are more characters outside BMP than just emoji.

[ Parent | on HN ]

Re:In MySQL, don’t use “utf8”, use “utf8mb4” (2016) by Ryckes on Thursday June 14, 2018 @11:37AM (#17312444)

Sorry for not doing my research but, aren't there 4-byte regular characters from other languages? Is it all emojis and symbols?

[ Parent | on HN ]