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!

NLS_LENGTH_SEMANTICS in 11.2 change permanently to CHAR?

John-MKAug 18 2014 — edited Aug 18 2014

Hello,

I have created 11.2.0.3 database with AL32UTF8 and UTF8, NLS_LENGTH_SEMANTICS is set to BYTE (default). But I have to change it to CHAR permanently regardless of the recommendation not to change it. In all the other databases we have this value set to CHAR.

v$nls_parameters and nls_instance_parameters are showing as CHAR but nls_database_parameters not.

How can I fix this?

Thanks a lot

Best regards

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 15 2014

Added on Aug 18 2014

#database-key-features, #globalization-support

10 comments

14,522 views