Skip to Main Content
Forums

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.

NVARCHAR2 in Oracle9i PROBLEM

gansanNov 17 2003 — edited Nov 18 2003
Hi
We have a database in US7ASCII using oracle9i r2 in AIX 5.1. We want to add NVARCHAR2 fields to support NLS progressively.

Scenario 2:With following configuration(v$nls_parameters):
DB character set - US7ASCII
NLS Character set - UTF8

Any insertion of values into the nvarchar2 (USING n LITERALS LIKE N'TEST' and select produces ???.

Scenario 2: The same insertion and selection works if
DB character set - UTF8
NLS Character set - UTF8


The value of NLS_LANG was tried using AMERICAN_AMERICA.UTF8. Looks like NLS_LANG does not really matter in this case. The question is how to make Scenario 1 work? We are not ready to convert the db char set to UTF8 at this stage.

Please help
Thanks in advance

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 16 2003
Added on Nov 17 2003
#database-key-features, #globalization-support
3 comments
445 views