UTF-8mb4 support - or where are the emojis 😱

adam · February 4, 2021, 9:01pm

Hi Pierre,

We don’t have a public roadmap right now. This is something I have brought up internally though to see what we can do in the future.

The 7.5 release is targeting June/July time frame.

-Adam

pierre · May 3, 2021, 7:42pm

Hi @adam, could you please confirm that this feature is still planned for the next release in June?

We need this asap actually to avoid doing dirty content encoding pre+post DB queries to handle emojis in content.

Thanks

adam · May 3, 2021, 7:54pm

Yes, it will be in the 7.5 release (still on track for July). The feature is complete at this point.

-Adam

pierre · May 4, 2021, 12:07pm

Awesome! looking forward

msayed · July 12, 2021, 7:16am

What if you need to do search on the encoded column ?
Is there any way to do search on “\u0628\u06cc\u0627” ?

hanson · July 14, 2021, 11:57pm

What do you mean an encoded column? You’ll be able to filter a utf8mb4 column in the WHERE condition against a literal (containing extended utf8mb4 characters) using all the existing comparison operators <, =, LIKE, etc.