OraFAQ Forum: Client Tools » Inserts Chinese Characters using INSERT INTO doesn't work

Home » Other » Client Tools » Inserts Chinese Characters using INSERT INTO doesn't work (SQL Navigator 5.5)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Inserts Chinese Characters using INSERT INTO doesn't work [message #286784]

Mon, 10 December 2007 02:12

pe00320
Messages: 1
Registered: December 2007
Location: Mexico

Junior Member

Hi,

I'm trying to insert this line into Oracle Database 10g (unicode) using SQL NAvigator and what it inserts are characters that are not chinese, like this: ¼��: �¤��¾�Ų��line��ƥ��, why?

INSERT INTO system_message (message_code, message_type, message_text, corrective_actions, short_message)
VALUES ('VB02-001','I','简体中文: 工作站号不与line相匹配
',简体中文: 请联系系统帮助部门','简体中文: 工作站号码与装配线不匹配')
;
But If I copy the chinese text and paste it directly in the record, I can see the chinese characters in database, because it is unicode. So, seems like the DML doesn't support chinese characters.

Any help is welcome
Magda

Report message to a moderator