PeopleSoft PeopleTools 8.48 and HRMS 8.9 Multilingual Oracle Database Install

PeopleTools 8.48 and PeopleSoft HRMS 8.9 w/Multilingual Oracle Install

The first createdbxx.sql script shows an incorrect way to create a PeopleSoft Database for a Unicode Installation. The second script is correct.

In this situation, the user has created the database using the incorrect character set WE8ISO8859P15:
Here is the create database script:
>
> CREATE DATABASE HRDMO
> maxdatafiles 1021
> maxinstances 1
> maxlogfiles 8
> maxlogmembers 4
> CHARACTER SET WE8ISO8859P15
> NATIONAL CHARACTER SET UTF8

I compared this to the script for a successful unicode install:
SQL> CREATE DATABASE HR89DMO
2 maxdatafiles 1021
3 maxinstances 1
4 maxlogfiles 8
5 maxlogmembers 4
6 CHARACTER SET UTF8
7 NATIONAL CHARACTER SET UTF8

For additional information, please refer to the PT8.4x Installation guide for Oracle (Task on “Planning Multilingual Strategy”). The following is an extract from the task:
Using Unicode Databases
In addition to supporting several legacy character sets, PeopleSoft supports creating Oracle databases using Unicode. Unicode enables you to maintain data in virtually any modern language in a single database. Prior to Unicode, many languages could not coexist in one database, as they did not share a common character set. To create an Oracle Unicode database, you must specify the character set UTF8 in the CREATE DATABASE statement. PeopleSoft triples column sizes when running against a Unicode Oracle database, as all Oracle
column sizes are measured in bytes, and PeopleSoft uses character-based column sizes. This tripling in size represents the worst-case 1-to-3 ratio of characters-to-byte for Basic Multilingual Plane Unicode characters
when represented in UTF8.