What kind of database is yours?
Recently I found an interesting article on how to find out whether a particular database is on UNICODE or not. Here is it.
PeopleTools 8.46, 8.47, 8.48, and 8.49 – How Do You find out if Oracle Database has been installed as Unicode Unicode DB must be using a supported Oracle/PeopleSoft unicode character set. (UTF8) You can check what is the value by running the following query in the DB instance in question.
SQL> SELECT PARAMETER, VALUE from V$NLS_PARAMETERS where PARAMETER=’NLS_CHARACTERSET’;
PARAMETER VALUE
—————
NLS_CHARACTERSET UTF8
In addition, PeopleTools must be told that it is utilizing a UNICODE db and that is done by the setting of the UNICODE_ENABLED boolean flag on the PSSTATUS table. A value of 1 indicates this DB is to be treated by tools as a UNICODE DB.
SQL> SELECT UNICODE_ENABLED from PSSTATUS;
UNICODE_ENABLED
—————
1
