Storing Emoji Character codes in DB

PHPMaker General Discussion (PHPMaker)
1

I’m trying to store emoji character codes in my database. I’m using utf8mb4_unicode_ci as my DB collation but the characters are saved in the database as ???. How can I allow HTML character codes to be saved?

2

That probably means your emoji character is not in utf-8. Also make sure your table is also using utf-8 (utf8mb4) charset and set MySQL charset to “utf8mb4”.

3

Setting the MySQL charset (for SET NAMES) in advanced settings did the trick. Thank you so much!