Android and iOS emoji

[montuy337513]

I put this request here.
Why are multibyte emojis replaced by ? Concerns different modules (newBB, wgGallery, ..). Tables and data are in mb4
People use their phones more and more often and therefore also use the emojis of their phones. it's a pity that they are not taken into account.
Insert via form -> emoji replaced by a ? in the database.
Inserting the emoji directly into the database -> the display is replaced by ??

[mambax7]

How are these emojis inserted? Using what editor?
Is it part of a DHTML field or regular field?
Can you give an example of text with the emoji and a particular module where we could test it?
Right now I don't know how to test it, with what emojis, which module and which form...

[LaurentMathieu2]

Hello, in the DHTML, in NewBB, impossible to use android and iphone smiley. Like the following ones 🤔🤔.

[geekwright]

Emoji characters are 4 bytes long in UTF-8. MySQL has to use utf8mb4 as the character set for any columns that will hold emoji. MySQL has defaulted to utf8mb3 until recently, so just using utf8 is not sufficient, The entire chain from your HTML to the database tables and back have to be capable of 4 byte UTF-8. If MySQL is asked to store a 4 byte UTF-8 value in a utf8mb3 column, it will throw an error.