Re: UTF8 Chinese String Comparison

[CL Chuah]

Oh yah, for the corrupted data, i simply do this in PHP

1) Create DB connection-1 to table [test_utf]
SET NAMES latin1; -- or leave it to default
SELECT * FROM test_utf;

2) Create DB connection-2 to table [test_utf_clean]
SET NAMES utf8;

3) Loop every records from [test_utf]
- dynamic generate "INSERT INTO test_utf_clean VALUES (....)"
- execute the statement on connection-2

A quick fix, anyone with pure MySQL statements to do this (without PHP)?