Database transcoding Solutions

Database transcoding
Before in the database to write the data did not execute mysql_query ("SET NAMES UTF8"), cause my database of Chinese is garbled, browse is can normal display, ask there is no way to convert the database garbled, converted to UTF8?

------Solution--------------------
read out in one way (without set names), transcode if necessary, and finally deposited in another way (plus set names).

------Solution--------------------
Library/table character set to use UTF
And then take a look at it, really not, just use the program to insert it, build a new library
------Solution--------------------
http://www.discuz.net/forum.php?mod=viewthread&tid=650717

http://www.baidu.com/s?wd=mysql+%CA%FD%BE%DD%BF%E2%D7%AA%C2%EB&rsv_bp=0&rsv_spt=3&inputT=9929
------Solution--------------------
In the output data with PHP function Iconv ("gb2312", "UTF-8", $str) to convert the string is OK.
------Solution--------------------
Export the database to a. sql file and rewrite it with Iconv ("gb2312", "UTF-8", $str) to import the new. SQL that will be generated.

