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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Problem with chinese character

Venkadesh Sivalingam-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,436 views