Taiwanese Characters in mysql
Posted by: Raji Ram
Date: January 26, 2011 11:17PM

Hi,

I am trying to insert Taiwanese Characters in my database and I used
SET NAMES 'utf8' COLLATE ''utf8_unicode_ci';
But in the insert statement I am able to view only '?' instead of Taiwanese characters.

This is my SQL statement:

CREATE TABLE tj (s1 CHAR(1) CHARACTER SET utf8 COLLATE utf8_unicode_ci);

This is my actual SQL query:
INSERT INTO tj VALUES ('搶'),('搶');

But in mysql,it appears as
INSERT INTO tj VALUES ('?'),('?');

Can anyone please suggest to to solve this?

Thanks and Regards,
Raji.

Options: ReplyQuote


Subject
Views
Written By
Posted
Taiwanese Characters in mysql
3477
January 26, 2011 11:17PM
1578
January 30, 2011 12:01AM


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.