MySQL Forums
Forum List  »  Newbie

Re: Chinese Characters showing like boxes
Posted by: Rick James
Date: April 13, 2016 06:05PM

Multiple question marks (3 or 4 per Chinese character) usually means that the column is not declared with CHARACTER SET utf8mb4.

Let's diagnose it...

SELECT col, HEX(col) FROM tbl WHERE ...

to see some character that is giving trouble.

If the hex is '3F', that's a question mark stored in the table.
If it is Exyyzz or Fwxxyyzz, then it is probably a correctly-encoded (for utf8mb4) Chinese character.

Options: ReplyQuote


Subject
Written By
Posted
Re: Chinese Characters showing like boxes
April 13, 2016 06:05PM


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.