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: Reply• Quote


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