Oracle Database Discussions

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!

insert/update japanese langunage data in a column of datatype varchar2(..)

VJ4May 9 2011 — edited May 10 2011

Hello,
I am using ORACLE DATABASE 11g (EE) and RHEL 5.

I want to insert/update japanese language data in a column which has the datatype as varchar2(256).

I tried to change the NLS_LANGUAGE and NLS_TERRITORY parameters with 'ALTER SESSION set ...' command but no effect.

I tried to bounce back ( shutdown and startup ) the DB but still no effect.

I tried to inset the NLS_LANGUAGE and NLS_TERRITORY in init.ora file but still no use.

If anybody knows the detail steps which i have mentioned above .... let me know. Might be that i am wrong in my method.

Can you please guide me how to change the language of DB for a perticular session to japanese ???

Thanks in advance...

Edited by: VJ4 on May 9, 2011 6:21 PM

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 7 2011

Added on May 9 2011

#general-database-discussions

7 comments

1,251 views