MySQL Forums
Forum List  »  Quality Assurance

Chinese Characters in mysql ?
Posted by: Loga Guhan
Date: January 31, 2013 03:47AM

Hello All,

am new to mysql.Am trying to insert Chinese Characters to my table in mysql DB.
The query is as follows,
insert into tbltest values(1893,'太原星河湾酒店 ','asgvsd');

but once inserted th chinese characters are displayed as '??????'.

I executed the following,


ALTER DATABASE testtb CHARACTER SET utf8 COLLATE utf8_general_ci;

ALTER TABLE tbltest CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;

Options: ReplyQuote


Subject
Views
Written By
Posted
Chinese Characters in mysql ?
12170
January 31, 2013 03:47AM
30548
February 15, 2013 07:43AM


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.