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
1610
November 25, 2015 04:42AM
825
November 29, 2015 11:25AM
873
November 30, 2015 01:24AM
Re: Chinese data not appraing
858
December 01, 2015 06:14PM
874
December 02, 2015 01:12AM
819
December 07, 2015 01:22AM
801
December 07, 2015 10:24AM
694
December 08, 2015 08:58PM
799
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.