Excel import MySQL garbled related issues! Tokyu

Excel import MySQL garbled problem! Tokyu
I import MySQL from Excel a total of more than 2000 records, is a lot of traditional Chinese character data, the PHP program is also found in some garbled. Only in the page toolbar to view the selection of Chinese Simplified database data is not garbled, but the page of Chinese characters (not read from the database) and become garbled, What utf-8,gbk,gb2312 have tried, or garbled, either the page of Chinese characters garbled or from the database isolated from the traditional Chinese characters garbled, now we have any method or write what code to open a page will not garbled, thank you!

------Solution--------------------
mysql_query ("Set names Big5 '");

Is it useless to do this?
------Solution--------------------

When you import a database
mysql_query ("Set names ' UTF8 '");
It is also advisable to convert all the read from Excel to Utf-8 and then into the database

read out the same mysql_query ("Set names ' UTF8 '");


------Solution--------------------
Excel export problems try exporting to UTF8
------Solution--------------------
What's the situation and version of your environment in addition?

The presentation file came over to help you write it ~ ~
------Solution--------------------
Concern
------Solution--------------------
I exported encountered garbled, changed the code on OK

That's not going to work, and I don't know why ........ ...........
------Solution--------------------
discuss
Now the garbled problem solved, first to convert the Excel file into the utf-8 format txt and then save as CSV format file, so the import will be UTF-8 format!
But there are new problems, is the import of each column as long as the first character is Chinese characters, insert the database will be empty, read out is also blank, in addition to the column of the first character is not the Chinese characters can read out the display, really dizzy dead, who knows what is going on, thank you!

