NLS_LENGTH_SEMANTICS – Why not in the init.ora?

.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_SEMANTICS parameter to CHAR in 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:

Continue reading...