Re: UTF-8 problem

[Rick James]

* 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.