.Few days ago at the Upgrade and Migration Workshop in Hamburg when I did talk about Unicode Migrations a customer had an interesting question.
“Why does the documentation states NOT to set
NLS_LENGTH_SEMANTICSparameter toCHARin the init.ora/spfile to enable char semantics for newly build objects by default?”
Honestly I was not aware of that hint. So I did some research and tried to get an answer from the developers.
The documentation says clearly not to set that parameter permanently:
- Oracle Database Reference on
NLS_LENGTH_SEMANTICS-
Caution:
Oracle strongly recommends that you do NOT set theNLS_LENGTH_SEMANTICSparameter to
-
