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 ?