12
Well, since the question is very self-explanatory I will only reinforce the question.
I have an APP chat system, which through the HTML, command to PHP with Ajax
, but if the usurer tries to insert some emoji (Emotion) from your device in the database it receives: "?????" as a message.
How can I change this to receive some kind of code for each Emotion and on the site list according to its value?
Very interesting question. The short answer would be: Convert the Character set from your table to
utf8mb4
, since this format accepts all Unicode characters.– Kazzkiq
I’ve tested it that way, but it didn’t work..
– Pedro Quezado
Even changing your column or table to utf8mb4 did not work?
emojicolumn VARCHAR(255) CHARACTER SET utf8mb4
? On the table:ALTER TABLE tabela CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
?– AlfredBaudisch
In addition to changing the charset, run this SQL before all calls involving Emoticon:
SET NAMES utf8mb4
;.– AlfredBaudisch
How is it being done is called ajax? This may be the problem too.
– Guilherme Nascimento