Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Problem with chinese character

Venkadesh-OracleJan 30 2015 — edited Feb 2 2015

Hi,

i am trying to insert and select chinese char but am seeing '???' i did below steps. please help

alter session set NLS_LANGUAGE='SIMPLIFIED CHINESE';

ALTER SESSION SET NLS_TERRITORY='CHINA';

CREATE TABLE TT(NAME NVARCHAR2(200));

INSERT INTO TT VALUES('您好');

COMMIT;

SELECT * FROM  TT;

NAME

-------------

¿¿

¿¿

select unistr('\8349') from dual;

i don't understand why am not able to see chinese char even though i inserted chinese. plese help

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 2 2015
Added on Jan 30 2015
14 comments
5,609 views