Re: Convert latin1 to utf8 problem

[Rick James]

What bytes do you have on your php page? How do you know?

"In my php page, I set charset is utf8
when the data is inserted to mysql database:
mysql_query("SET NAMES 'utf8'")" -- that declares that the bytes you have in php are really characters encoded in utf8.

"the database's charset is latin1." -- OK, but have you overridden it on at the CREATE TABLE? Please SHOW CREATE TABLE foo;