MySQL Forums
Forum List  »  Newbie

Re: UTF-8 problem
Posted by: Rick James
Date: October 31, 2009 11:04AM

* Do you have the proper "meta" tag at the beginning of the web page(s)?
* Do you use SET NAMES utf8 immediately after connecting?
* Did you use SET NAMES utf8 when you inserted the data?
* Are the relevant columns declared "utf8" (collation is not important for the encoding, just for the sort ordering)?

Please do this to pull out a few cases of "?":
SELECT x, LENGTH(x), CHAR_LENGTH(x), HEX(x) FROM tbl WHERE ... LIMIT...;
From that I should be able to deduce if the data was improperly stored.

Options: ReplyQuote


Subject
Written By
Posted
October 27, 2009 04:24PM
Re: UTF-8 problem
October 31, 2009 11:04AM
November 01, 2009 08:17AM


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.