How to save emojis in mysql db from r shiny?

[Ankush]

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?

[pieterjanvc]

Hi,

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.

How to store Emoji Character in MySQL Database

Hope this helps,
PJ

[Ankush]

Hi,

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..