Issue with UTF-8 in MYSQL 5.7

[Shanu Kumar]

Hi everyone,

Greetings. My name is Shanu. I am a developer in this company called Typeset (www.typeset.io).

We use MySQL 5.7 internally in our company, and I am constantly running into UTF-8 troubles. Would want to describe the instance.

On the frontend, we have real-time Editor on which the user can enter the data. Once the user enters this data, it should be stored properly in the database. However, here are the results I can see in the database:

(a.) Question marks (????) instead of Chinese/ Japanese characters.
(b.) Black diamonds coming up, such as Mi�uel.
(c.) Random text (eg. æ–°æµ for 新浪)

What should I do? I have done research on the internet, but not able to clearly understand. Any help in the right direction would be appreciated.