patternMinor
Are there any known problems caused by having NLS_LENGTH_SEMANTICS set to CHAR on an Oracle database?
Viewed 0 times
nls_length_semanticsoraclearesetanyhavingchardatabaseknownproblems
Problem
I've always thought that anyone using a database where
NLS_LENGTH_SEMANTICS set to BYTE when using a multi-byte character set needed their heads examined, but recently a customer of ours said that they had experienced problems applying Oracle patches on databases where NLS_LENGTH_SEMANTICS is set to CHAR. Is there anything to this? Is it a known problem?Solution
According to the documentation:
Oracle strongly recommends that you do NOT set the NLS_LENGTH_SEMANTICS parameter to CHAR in the instance or server parameter file. This may cause many existing installation scripts to unexpectedly create columns with character length semantics, resulting in runtime errors, including buffer overflows.
Oracle strongly recommends that you do NOT set the NLS_LENGTH_SEMANTICS parameter to CHAR in the instance or server parameter file. This may cause many existing installation scripts to unexpectedly create columns with character length semantics, resulting in runtime errors, including buffer overflows.
Context
StackExchange Database Administrators Q#117710, answer score: 3
Revisions (0)
No revisions yet.