Emogi in String data field not being detected for all records

Hey All,
I have pulled data from MySQL into Quicksight, wherein the ‘title’ column has emogi’s as well.

But emogi is reflected in one of the title only, for the rest it is showing ‘?’ in place of emogi.

How do I get this solved???

Thanks,
Ummehaani

Hey All,
To store the emoticons in MySQL we have used utf8mb4 character set and then fetched into Spice.
I want to know which character set is supported for emoticons in Quicksight?

Thanks,
Ummehaani