MYSQ GBK Write, Utf-8 extract, how to handle

MYSQ GBK Write, Utf-8 extract
My MySQL database is edited as Utf-8, and the data in it is written in GBK. Because the usual extraction is also set GBK, so although the database is garbled, but the extraction is normal ... This data must now be extracted in a utf-8 environment. Ask the great God, how to deal with the normal display????
Do not blame the few points.

------Solution--------------------
According to reason, take the GBK display to turn into utf-8. Specifically, it has to be tested.
It's better to be unified.
------Solution--------------------
"Set names UTF8" before querying data to display normally in utf-8 environment
------Solution--------------------
mysql_query (' Ste names UTF8 ');

------Solution--------------------
mysql_query (' Ste names UTF8 ');
Set encoding
------Solution--------------------
Iconv
------Solution--------------------
is the field type UTF8?
Have you used set names GBK before?
Use Length (...) Measure the length of Chinese characters, if normal, use set name UTF8
Otherwise, export the encoding at the beginning of the file and then import


discuss
My MySQL database is edited as Utf-8, and the data in it is written in GBK. Because the usual extraction is also set GBK, so although the database is garbled, but the extraction is normal ... This data must now be extracted in a utf-8 environment. Ask the great God, how to deal with the normal display????
Do not blame the few points.

------Solution--------------------
discuss

The problem is solved. It's weird. Extraction can not be used when the set names Utf-8 extracted to display the time with the ICONV function processing. Thank you very much, everybody split

