If you have UTF-8 encoded data in a MySQL table that has character set set to Latin1 you can use the following SQL statement to correctly decode it:
SELECT CAST(BINARY(value) AS CHAR CHARACTER SET utf8) AS value
Jun 21
If you have UTF-8 encoded data in a MySQL table that has character set set to Latin1 you can use the following SQL statement to correctly decode it:
SELECT CAST(BINARY(value) AS CHAR CHARACTER SET utf8) AS value