Re: Chinese Charset is displayed as '????'
Posted by: Frankie.ngai
Date: March 16, 2005 03:56AM

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...

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Chinese Charset is displayed as '????'
5458
March 16, 2005 03:56AM
3893
November 03, 2005 01:55AM
19265
January 18, 2007 09:47PM
5251
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.