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.
Subject
Views
Written By
Posted
11540
March 02, 2005 04:41AM
7853
March 02, 2005 08:02AM
6072
March 02, 2005 07:54PM
6101
March 03, 2005 02:23AM
8688
March 05, 2005 03:54AM
5507
March 16, 2005 03:56AM
4762
April 05, 2005 03:13AM
6298
April 06, 2005 09:10AM
4192
October 24, 2005 10:47PM
3953
November 03, 2005 01:55AM
3788
April 21, 2005 07:45AM
Re: Chinese Charset is displayed as '????'
7469
June 28, 2005 10:44PM
3831
November 03, 2005 03:01AM
3529
December 01, 2005 09:34PM
3618
December 08, 2005 03:06AM
3332
July 13, 2005 03:18AM
3570
August 15, 2005 01:58PM
19516
January 18, 2007 09:47PM
5307
October 24, 2005 11:41PM
3690
October 25, 2005 02:07AM
3402
November 04, 2005 09:40AM
3374
March 22, 2006 04:03AM
3460
April 05, 2006 10:01AM
4388
May 25, 2006 01:33PM
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.