Re: Chinese Charset is displayed as '????'
Posted by: ahmad
Date: June 28, 2005 10:44PM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
3893
November 03, 2005 01:55AM
Re: Chinese Charset is displayed as '????'
7405
June 28, 2005 10:44PM
19267
January 18, 2007 09:47PM
5253
October 24, 2005 11:41PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.