Issue with UTF-8 in MYSQL 5.7
Posted by: Shanu Kumar
Date: April 11, 2021 01:56AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Issue with UTF-8 in MYSQL 5.7
421
April 11, 2021 01:56AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.