I'll create one custom table in Magento 1 to store the data.

I want to store emoji in my custom table and display it in the frontend
I'll store data something like 'Hdhdhdh😜😀😊😃hzhzhzz'
but it displays like Hdhdhdh????????????????hzhzhz

How to solve this?


Change your table's fields COLLATE where you are saving emoji From CURRENT to COLLATE 'utf8mb4_bin'.

|improve this answer|||||
  • Still in frontend it show as ????? – Jigs Parmar May 15 '18 at 11:31
  • May I know your code for fetch that data? – kunj May 15 '18 at 11:41

Not the answer you're looking for? Browse other questions tagged or ask your own question.