Oracle DB semantics Character set for upgrading application from Pega 7.1.9 to 8.5.3.
Hi,
We're in the process of Pre-Upgrade of our application from PRPC 7.1.9 to 8.5.3. version.
We've seen the following Oracle DB settings in Pega 8.5.3. Platform Upgrade Guide. "Verify that Oracle semantics is set to CHAR to support localization: 1. On the database server, open the file SPFILEDBNAME.ora in the database directory. 2. Verify that the settings are as follows: NLS_LENGTH_SEMANTICS=CHAR scope=both; NLS_CHARACTERSET=AL32UTF8; NLS_NCHAR_CHARACTERSET=AL16UTF16; 3. If the semantics settings differ, migrate the database character set."
Currently on our Oracle 11g DB we have NLS_LENGTH_SEMANTICS=BYTE .
it's necessary to change the NLS_LENGTH_SEMANTICS or we can keep this one?
this setting is only necessary to avoid errors on 2 byte characters?
thank you, Andrea
Accepted Solution
Updated: 16 Mar 2022 14:30 EDT
Citicorp Services India Private Limited
IN
Hello @AndreaG86,
It is suggested to go with the setting defined in platform upgrade guide. Following community link describes more info on issues related to this setting.
Thanks,
Accenture SPA
IT
@AndreaG86 add a reply to avoid automatic closure.
Accepted Solution
Updated: 16 Mar 2022 14:30 EDT
Citicorp Services India Private Limited
IN
Hello @AndreaG86,
It is suggested to go with the setting defined in platform upgrade guide. Following community link describes more info on issues related to this setting.
Thanks,