How to deal with mysqgbk writing and UTF-8 extraction

Mysqgbk write, UTF-8 extract my mysql database and edit it as UTF-8, the data in it is written using gbk .. Because gbk is usually set during extraction, although the database contains garbled characters, the extraction is normal... The data must be extracted in the UTF-8 environment .. Ask the gods how to deal with mysq gbk writing, UTF-8 extraction
My mysql database is edited as UTF-8, and the data in it is written in gbk .. Because gbk is usually set during extraction, although the database contains garbled characters, the extraction is normal... The data must be extracted in the UTF-8 environment .. What can I do if I can display it normally ????
Not to blame ..

------ Solution --------------------
In principle, gbk is used to convert the image to UTF-8. Test is required.
It is best to achieve unification.
------ Solution --------------------
"Set names utf8" can be properly displayed in the UTF-8 environment before data query.
------ Solution --------------------
Mysql_query ('Ste names utf8 ');

------ Solution --------------------
Mysql_query ('Ste names utf8 ');
Set encoding
------ Solution --------------------
Iconv
------ Solution --------------------
The field type is utf8?
Have you used set names gbk before?
Use length (...) to test the length of Chinese characters. if it is normal, use set name utf8.
Otherwise, after the export is used, change the encoding at the beginning of the file and then import it.


Discussion
My mysql database is edited as UTF-8, and the data in it is written in gbk .. Because gbk is usually set during extraction, although the database contains garbled characters, the extraction is normal... The data must be extracted in the UTF-8 environment .. What can I do if I can display it normally ????
Not to blame ..

------ Solution --------------------
Discussion

The problem is solved .. A little strange .. The iconv function cannot be used to extract and display data from set names UTF-8 during extraction .. Thank you very much.