0

When i stored emojis in database it represents question marks sign but when i fetched from database its unicode characters display which is accurate. But my question is why unicode character of emoji are not stored in database instead question marks sign mark are stored.

Gurpinder
  • 634
  • 1
  • 5
  • 18
  • 2
    It's stored correctly, but rendering as question marks in your command line. Otherwise, you can't retrieve. – Abimaran Kugathasan May 26 '14 at 10:14
  • Where and how do you see that the characters are stored as "????". Perhaps whatever application you view the data in doesn't use a font that displays the characters properly. – nos May 26 '14 at 10:15
  • I viewed my database in my phpmyadmin. – Gurpinder May 26 '14 at 10:16
  • It stored as ??? but when i fetch using SELECT the emoji's unicode characters are displayed in JSON – Gurpinder May 26 '14 at 10:22
  • @nos I just want to confirm is emjoji's are stored ??? when collation is utf8mb4_unicode_ci? because when my collation is utf8_general_ci the emoji's unicode characters stored instead of ??? – Gurpinder May 26 '14 at 10:24

0 Answers0