Uploading UTF-8 Chinese CSV file to MYSQL database

- something wrong..please help

[wantfieldh]

I have been having trouble with my website which is built with UTF-8 to allow both english and Chinese. I am contracting someone to develop a feed for my website similar to the froogle feed, where we can maintain our database on CSV file and upload, replace or add to the existng. The problem is, I would enter chinese in the CSV file, it would look fine, but when I upload it, it would come out of the front end as Traditional Chinese Encoding, which is not consistant with rest of my site.

If I turn my browser encoding to chinese-big-5(non-unicode), than I can read my uploaded listings. however, since rest of my site is built with UTF-8, it is not consistant.

I have tried uploading the XLS version which supports "Arial Unicode font", but that doesnt work either. Everything shows up as?

The other way around, when I enter chinese directly in to my site through front end, everything is fine. However, when I export my chinese listings out, it also shows as "?" in my newly exported CSV file.

I REALLY NEED HELP! APPRECAITE IT!