Re: Chinese Charset is displayed as '????'

[ahmad]

Hi,

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

If I copy the displayed SQL from the browser and paste into PhpMyAdmin Sql box the big5 chinese data is somehow converted to unicode and inserted correctly and also displayed correctly

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

The Collation for the whole table is big5_chinese_ci and I still face this problem.

Thanks for your help
Ahmad
Hong Kong



Edited 1 time(s). Last edit at 06/28/2005 11:12PM by ahmad.