Skip to Main Content

Oracle Database Free

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Please ask technical questions in the appropriate category. Thank you!

NLS_LENGTH_SEMANTICS=CHAR ignored on FREE 23.3

Tailor K.Oct 4 2023 — edited Oct 13 2023

Hello,

I am trying the new Oracle 23.3 to migrate a ‘classic’ database from XE 18c (created by hand as WE8MSWIN1252) to the new unicode db.

Then I set NLS_LENGTH_SEMANTICS=CHAR at database level and used impdp - that's fine. But when i type a new create table with varchar2(nn) columns, it does not convert to varchar2(nn char) like the imported ones.

Even repeated the parameter at session level, and in container DB - no success … I have to explicitly put the ‘extended’ syntax when creating a new table by had - why is that ?

This post has been answered by Chris Saxon-Oracle on Oct 5 2023
Jump to Answer
Comments
Post Details
Added on Oct 4 2023
3 comments
226 views