MySQL Forums
Forum List  »  PHP

Re: Asian language problems
Posted by: Rick James
Date: February 28, 2009 03:11PM

Since lots of layers do try to convert characters for you, sometimes things are set up such that there is double conversion. I am trying to find clues of such...

* I see the call to mysql_set_charset(); look up SET NAMES to see if there are other settings you should apply.

* イ looks like something applied htmlentities() to the data.

* Please do this on some short field in the table:
SELECT length(col), char_length(col), col FROM TABLE ...;
I would expect the length() to be 3x the char_length() if 'col' contained only Japanese characters.

* Your fields are set to charset utf8? (Not just collation.) Check with SHOW CREATE TABLE tbl\G

Options: ReplyQuote


Subject
Written By
Posted
February 27, 2009 07:53PM
Re: Asian language problems
February 28, 2009 03:11PM
March 04, 2009 04:25PM
March 04, 2009 10:49PM
March 05, 2009 11:39AM


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.