Siebel Data Warehouse Installation and Administration Guide > Preinstallation Considerations for Siebel Data Warehouse > Deploying Siebel Data Warehouse in Latin-1 General, Unicode and Non-English Environments >

Source and Data Warehouse Code Pages for Code Page to Code Page

The following code pages are supported for source databases:

• JPN16JIS (for Oracle).
• 943 (for DB2).

The following code pages are supported for data warehouse databases:

• UTF8 and AL32UTF8 are supported for Oracle.
• UCS-2 is supported for DB2.

The following environment variables need to be set before you begin the installation process:

• NLS_LANG (for Oracle). For instructions, see To set the NLS_LANG environment variable for Oracle databases.
• DB2CODEPAGE (for DB2). For instructions, see To set the DB2CODEPAGE environment variable for DB2 databases.

The following environment variables need to be set during the configuration process:

• Informatica Server Data Movement. For instructions, see To configure the Informatica Server.
• SiebelUnicodeDB. For instructions on Windows, see Setting the SiebelUnicodeDB Environment Variable on Windows. For instructions on UNIX, see To set SiebelUnicodeDB on the Informatica Server if source and target databases are Unicode on UNIX.
• If the Informatica Server is running on UNIX, then you also need to set the PMREPCODEPAGE environment variable appropriately. For example: PMREPCODEPAGE=MS932.

The following information uses <LANG> = JPN as an example. If you are using a language other than Japanese, replace the code page with the appropriate language.

Informatica Server and Repository Server Running on Windows and OS <LANG>

Table 22 provides the code pages for the Informatica Server and the Repository Server running on Windows, both with OS <LANG>.

Informatica Server and Repository Server Running on UNIX and OS <LANG>

Table 23 provides the code pages for the Informatica Server and the Repository Server running on UNIX, both with OS <LANG>.

Informatica Server on UNIX, Repository Server on Windows, Both with OS <LANG>

Table 24 provides the code pages for the Informatica Server running on UNIX and the Repository Server running on Windows, both with OS <LANG>.

To set the NLS_LANG environment variable for Oracle databases

1. Determine the NLS_LANG value.
   1. In the data warehouse database, run the command

   SELECT * FROM V$NLS_PARAMETERS

   2. Make a note of the NLS_LANG value, which is in the format [NLS_LANGUAGE]_[NLS_TERRITORY].[NLS_CHARACTERSET].

      For example: American_America.UTF8

2. For Windows:
   1. Navigate to Control Panel > System and click the Advanced tab. Click Environment Variables.
   2. In System variables section, click New.
   3. In the Variable Name field, enter NLS_LANG.
   4. In the Variable Value field, enter the NLS_LANG value that was returned in Step 1.

      The format for the NLS_LANG value should be [NLS_LANGUAGE]_[NLS_TERRITORY].[NLS_CHARACTERSET].

      For example: American_America.UTF8.

3. For UNIX, set the variable as shown below:

   setenv NLS_LANG <NLS_LANG>

   For example: setenv NLS_LANG American_America.UTF8.

   If your data is ASCII and the Informatica Server is running on UNIX, then set

   NLS_LANG <NLS_LANGUAGE>_<NLS_TERRITORY>.WE8ISO8859P1

4. Reboot the machine after creating the variable.

To set the DB2CODEPAGE environment variable for DB2 databases

1. Determine the DB2CODEPAGE value.
   1. In the data warehouse database, run the command

   SELECT CODEPAGE FROM SYSCAT.DATATYPES WHERE TYPENAME = 'VARCHAR'

   2. Make a note of the result.

      For example: 1208

2. For Windows:
   1. Navigate to Control Panel > System and click the Advanced tab. Click Environment Variables.
   2. In System variables section, click New.
   3. In the Variable Name field, DB2CODEPAGE.
   4. In the Variable Value field, enter the value that was returned in Step 1.
3. For UNIX, set the variable as shown below:

   setenv DB2CODEPAGE <DB2CODEPAGE value>

   For example: setenv 1208.

4. Reboot the machine after creating the variable.