Bookshelf Home | Contents | Index | Search | PDF

Siebel Server Installation Guide for Microsoft Windows > Installing the Siebel Server > Post-Installation Tasks for the Siebel Server >

Setting the Database Client Locale for Siebel Server

---

Before you configure the Siebel Database Server, you must set the language characteristics of your Siebel Servers.

CAUTION:  This procedure is required regardless of whether you install only one language pack or multiple language packs.

The code page of the operating system on which your Siebel Server runs must match that of your Siebel Database Server instance. The languages installed on each must also match. To find all the code pages supported by Siebel eBusiness Applications at mid-tier and code pages supported at the database level, refer to System Requirements and Supported Platforms.

Oracle

Siebel eBusiness Applications supports only binary collation sequencing in development environments. Therefore, either you must set NLS_SORT to BINARY or you must choose a Territory value that includes binary when setting the locale for your development environment.

To set locale parameters

From the Start menu, click Run.
Type regedit and click OK.
Select HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\.
In the right column, right-click NLS_LANG and select Modify.

The Edit String dialog box appears.

Change the entry to the appropriate language, territory (locale), and character set (for example, GERMAN_GERMANY.WE8MSWIN1252 for German as spoken in Germany), and then click OK.
From the Task bar, click Edit >New > String Value.

A placeholder for the new value (New Value #1) appears in the right column.

Select New Value #1, then, from the Task bar, navigate to Edit > Rename and rename it NLS_SORT.
In the right column, right-click NLS_SORT and select Modify.

The Edit String dialog box reappears.

Type the appropriate collation sequence and click OK.

NOTE:  Siebel eBusiness Applications only supports binary sorting in a development environment. For more information about supported collation sequencing for Oracle in development and production environments, see Creating the Oracle Database.

Quit the Registry Editor.

Microsoft SQL Server

When setting the language characteristics of your database for MS SQL Server, Siebel Systems recommends that you set the sort order at the database instance level only. For details on MS SQL Server sort orders supported by Siebel eBusiness Applications in development and production environments, see Creating the Microsoft SQL Server Database.

You can set the language per session by issuing the SET LANGUAGE command in the Query Analyzer.

DB2 UDB for Windows and UNIX

Setting the language characteristics of your database is part of creating your database instance. An editable command for this purpose is provided in Creating the DB2 Universal Database for Windows and UNIX and is part of the editable sample database creation script, located in Sample Database Creation Scripts.

Setting Database Client Locale for Siebel Server

You must set the target locale for your Siebel Servers, regardless of the database you use.

To set the target locale of the Siebel Server

From any Siebel Web Client application, access Server Manager and click
Screens >Server Administration >Servers.
Click the Server Parameters view tab.
In the Siebel Servers list, select the appropriate Siebel Server.
In the Server Parameters list, select the appropriate Language Code parameter.
In the Current Value field, change the value to the appropriate language for this Siebel Enterprise; for example, esn for Spanish.

For a list of all languages supported by Siebel eBusiness Applications and their codes, see System Requirements and Supported Platforms.

Bookshelf Home | Contents | Index | Search | PDF