Specifying Unicode Databases in PeopleSoft Systems

When the import has completed successfully, you must specify in your PeopleSoft system that the database is now a Unicode database. To do this, sign into the Oracle SQL utility of your choice using the database owner ID. Run the following SQL statement:

UPDATE PSSTATUS SET UNICODE_ENABLED=1

Note:

You must set the PSSTATUS field of UNICODE_ENABLED to 1 for all Unicode databases and 0 for all Non-Unicode databases.

Since you set ENABLED_DATATYPE previously, you also need to specify that the database uses Oracle CLOB and BLOB fields, as follows:

UPDATE PSSTATUS SET DATABASE_OPTIONS=34;