MySQL Forums
Forum List  »  Performance

Re: Chinese data not appraing
Posted by: Rick James
Date: December 01, 2015 06:14PM

Let's find out what is in the source table.

SELECT col, HEX(col) FROM source WHERE ...
Use something like that to fetch one cell with Chinese text in it; show it to me. That should confirm that the data is stored in utf8 (or gbk or ...). If it is not, then the INSERTs were broken; I may be able to say what went wrong.

I have not found any way to map ç›®æ to/from 目标
So, I fear that more than one thing has gone wrong.

Options: ReplyQuote


Subject
Views
Written By
Posted
1624
November 25, 2015 04:42AM
833
November 29, 2015 11:25AM
882
November 30, 2015 01:24AM
Re: Chinese data not appraing
864
December 01, 2015 06:14PM
883
December 02, 2015 01:12AM
830
December 07, 2015 01:22AM
810
December 07, 2015 10:24AM
703
December 08, 2015 08:58PM
804
December 09, 2015 01:04AM


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.