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.
Pegasystems Inc.
IN
This is only required if your application needs support of localization.
Otherwise you can still staty with your current DB settings.
Mphasis
IN
Localization is already part of our current application. We're using localization (German and English language only) for the application. We don't have requirements for any other langauge as of now.
As the current Production DB settings in 6.2 SP2 already has localization support, will the same DB settings can be kept for Pega 7.2.2. Upgrade?