Verifying System Preferences and Settings for the Database Code Page

This task is part of Verifying Installation for the Siebel Database.

After you complete installing Database Configuration Utilities and installing the Siebel database, you must verify system preferences and other settings for the Siebel application that indicate whether you are using Unicode, and indicate the code page that you are using.

For more information about code pages, see Planning RDBMS Installation and Configuration. For Siebel CRM language support, Unicode support, and legacy code page support, see the Certifications tab on My Oracle Support.

The following procedure assumes that you have already installed Siebel Tools.

For information about installing Siebel Tools, see About Installing Siebel Web Client or Siebel Tools.
For information about starting Siebel Tools, see Verifying Successful Installation of Siebel Tools.

To verify system preferences and settings for the database code page

Start Siebel Tools and connect to the Siebel database.
Navigate to Screens, System Administration, and then System Preferences.

Look for System Preference Name = Enterprise DB Server Code Page. Verify that the value has been set correctly, based on the value that you selected during the installation of the Siebel database components (see Installing the Siebel Database).

Note: The value of Enterprise DB Server Code Page must be in lowercase, for example, utf-8 or utf-16. An Oracle Database character set might have a different value, although the system preference value must be utf-8. The utf-16 code page is also known as UCS-2, although the system preference value must be utf-16.

Possible values for the system preference are listed in the following table:

Language	Database	Value
All	Oracle Database	utf-8 (for Unicode)
All	IBM DB2, Microsoft SQL Server	utf-16 (for Unicode)
Japanese	Oracle Database, IBM DB2	cp932 (or equivalent)
Western European	All	cp1252 (or equivalent)

Verify that the column UNICD_DATATYPS_FLG in the table S_APP_VER is set correctly. The flag value must be in uppercase.
Possible values for UNICD_DATATYPS_FLG are listed in the following table:

Code Page Database Value

Non-Unicode code page

All

N

Unicode

Oracle Database

8

Unicode

IBM DB2

Y

Unicode

Microsoft SQL Server

Y

Code Page	Database	Value
Non-Unicode code page	All	N
Unicode	Oracle Database	8
Unicode	IBM DB2	Y
Unicode	Microsoft SQL Server	Y

To specify that you are using an EBCDIC code page

If you are using an EBCDIC code page for DB2 on z/OS, then you must set the EBCDICCodePage parameter to specify that you are using this type of code page. This advanced parameter replaces the system preference of the same name. EBCDICCodePage is now a component level parameter and is recommended to be set at the component level.

The EBCDICCodePage parameter changes the sort order to ASCII in your EBCDIC database, which prevents intermittent workspace delivery failures related to the sort order of WS_SRC_ID records.

To set this parameter at the component level (such as an Application Object Manager component), run Server Manager and enter a command like the following:

change param EBCDICCodePage=TRUE for comp component_name

To set this parameter at the enterprise level, run Server Manager and enter a command like the following:

change entparam EBCDICCodePage=TRUE

If you are using Siebel Tools, then set this parameter in the [Siebel] section of the tools.cfg file, as follows:

[Siebel]
EBCDICCodePage=TRUE