Emoji inserted into MySQL

Question

I tried to add an emoji in chat box textarea with emoji image input but during the insertion time, i tried to var-dump the data, and that showed as below:

❤️❤️❤️❤️

I did not select any emojiis and inserted into the database

❤️❤️❤️????????❤️

like these, and I also did these steps

1) ALTER DATABASE CHARACTER SET utf8 COLLATE utf8_unicode_ci;

2) ALTER TABLE CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;

3) ALTER TABLE MODIFY VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci;

"thanks for @Timo Huovinen"

Any ways,I want to insert the emoji in database correctly, and after the insertion, the original emoji image should be listed.

Thanks in advance!!!

I'm still stuck at how you got those emoji into your question +1 — Tim Biegeleisen, Sep 22 '17 at 06:09
@Tim that emoji is :ok_hand: these codes .. any idea to show the result — Andrew, Sep 22 '17 at 06:31
See also "question mark" in https://stackoverflow.com/questions/38363566/trouble-with-utf8-characters-what-i-see-is-not-what-i-stored — Rick James, Sep 22 '17 at 19:26

score 0 · Answer 1 · answered Sep 22 '17 at 06:10

0

Parse the emojis as unicode characters before you insert them into your database, after that whenever you retrieve the emoji, just parse them back again.

Here's some info on that: http://crocodillon.com/blog/parsing-emoji-unicode-in-javascript

answered Sep 22 '17 at 06:10

チャールズ

123
1
7

Emoji inserted into MySQL

1 Answers1