Question

2
Replies
61
Views
nvuyyuru Member since 2009 14 posts
Mphasis
Posted: 3 years ago
Last activity: 3 years 6 months ago
Closed

Oracle DB semantics Characterset for upgrading application from Pega 6.2 SP2 to 7.2.2.

Hi,

We're in the process of Pre-Upgrade of our application from PRPC 6.2 SP2 to 7.2.2. version.

We've seen the following Oracle DB settings in Pega 7.2.2. Platform Support 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."

However currently our values in our application (Running on PRPC 6.2 SP2) in production are:
NLS_LENGTH_SEMANTICS BYTE
NLS_CHARACTERSET WE8MSWIN1252
NLS_NCHAR_CHARACTERSET AL16UTF16
We have the same values on our AES PROD database. AES is running on PRPC 7.1.7. So please let us know if this is really a precondition or not? Or do we need to migrate the oracle database character set? If so, it is going to big change for us.

Your early response is appreciated.

**Moderation Team has archived post**

This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.

Low-Code App Development Upgrades
Moderation Team has archived post
Share this page LinkedIn