Re: Chinese Charset is displayed as '????'
Table describe
+-------+-------------+-------------------+-
| Field | Type | Collation |
+-------+-------------+-------------------+-
| s1 | varchar(10) | latin1_swedish_ci |
| s2 | varchar(10) | utf8_general_ci |
+-------+-------------+-------------------+-
try this function
Convert('string' using utf8)
Insert into table1 values('k1',convert('[chinese string]' using utf8));
i success insert chinese character into mysql...
Subject
Views
Written By
Posted
12102
March 02, 2005 04:41AM
8029
March 02, 2005 08:02AM
6264
March 02, 2005 07:54PM
6244
March 03, 2005 02:23AM
8876
March 05, 2005 03:54AM
Re: Chinese Charset is displayed as '????'
5644
March 16, 2005 03:56AM
4924
April 05, 2005 03:13AM
6492
April 06, 2005 09:10AM
4384
October 24, 2005 10:47PM
4102
November 03, 2005 01:55AM
3952
April 21, 2005 07:45AM
7622
June 28, 2005 10:44PM
4006
November 03, 2005 03:01AM
3677
December 01, 2005 09:34PM
3755
December 08, 2005 03:06AM
3480
July 13, 2005 03:18AM
3728
August 15, 2005 01:58PM
19899
January 18, 2007 09:47PM
5449
October 24, 2005 11:41PM
3825
October 25, 2005 02:07AM
3572
November 04, 2005 09:40AM
3511
March 22, 2006 04:03AM
3639
April 05, 2006 10:01AM
4544
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.