Mojibake when uploading to mysql

[Max Petitjean]

Hi
I have a question regarding mysql font problem. I am using mysql on our
web hosting plan from websitesource.com
When uploading the data from a cvs file into the mysql database, some
Japanese fonts do not show the correct result on the browser
On our cvs file the following is shown
ソーヴィニヨン
however, the database somehow shows
メ[ヴィニヨン
could you please tell me why this is happening ?
I think, it can have something to do with the font collation, I tried
many different possibilities to upload but non so far gave me the
correct display.
I would appreciate if you could help me solve this problem, since our
page shows all the incorrect Japanese fonts.
please check on www.netwine.co.jp or www.alcotrade.com
Thanks you for your help.
Best regards
Max W. Petitjean