Storing big5 chars in mysql using php

[ahmad]

Hi experts,

This is my first experience storing Chinese characters in Mysql.

I want to import some chinese data stored in a csv file into Mysql using PHP. I have already written code to insert the data from csv to mysql but the chinese data (typed using big5) is getting corrupted (???) after inserted into the db.

For your information if I display the sql query in the browser before I insert it displays correctly when I change the browser encoding to Big5

Could you please help me by telling what are the things I need to follow to insert the big5 chars using php

Thanks for your help
Ahmad
Hong Kong