How to save emojis in mysql db from r shiny?

Hi all,

I have created a shiny application with some emojis as user's input. It's saving perfectly. But the emojis are not stored the db as it should be. Its saving like this-


Kindly help in this?


This is most likely because the default encoding of your database does not support this. You can change this to an encoding that does support it. Here is a link I found after a quick Google search, but you might need to search a bit further if it does not fit your database setup at the moment.

Hope this helps,


I did it actually. But it sometimes show emojis and sometimes ?????. I am doing all steps i.e changing database encoding, then table's and then column's. But still not showing properly..