Sunday, August 29, 2021

nls length semantics must be set to char

CHAR length semantics are required for the AL32UTF8 character set.

The following command can be executed when logged in as SYSTEM to make this change:

alter system set NLS_LENGTH_SEMANTICS = CHAR scope = both;