Pega 8 Setting NLS_LENGTH_SEMANTICS appropriately
We are performing an upgrade from Pega 6 to Pega 8 as part of the upgrade instructions the Pega-platform-85-upgrade-websphere-oracle.pdf guide states that:
NLS_LENGTH_SEMANTICS=CHAR be set at the SPFILE level
Oracle documentation reports this setting as inadvisable at that level -
"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 run-time errors, including buffer overflows."
Can you advise firstly on the appropriate way to define CHAR length semantics.
Secondly is installation with default BYTE semantics supported by Pega?