Siebel Installation Guide for Microsoft Windows: Servers, Mobile Web Clients, Tools > Installing the Siebel Server >

Setting the Siebel Server Locale

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 on Siebel SupportWeb.

You must set up the Siebel Server locale regardless of whether you install only one Language Pack or multiple Language Packs.

Setting the Server Locale for IBM 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 Guidelines for Configuring the RDBMS and is part of the editable Sample Database creation script, located in SIEBEL_ROOT\dbsrvr\DB2UDB directory.

To set the locale of the Siebel Server

1. From any Siebel Web Client application, access Server Manager and click Screens > Server Administration > Servers.
2. Click the Server Parameters view tab.
3. In the Siebel Servers list, select the appropriate Siebel Server.
4. In the Server Parameters list, select the appropriate Language Code parameter.
5. 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 on Siebel SupportWeb.

Setting the Server Locale for IBM DB2 UDB for z/OS and OS/390

The following procedure sets the locale on a Siebel Server machine running Windows. You must perform this procedure before adding the corresponding language to the Siebel Server.

To set the locale of the Siebel Server

1. Choose Start > Settings > Control Panel > Regional options.
2. In the Regional Options dialog box, click the General tab, and then click Set Default.
3. In the Select System Locale dialog box, select a locale, and then click Apply.
4. To exit the Regional Options dialog box, click OK.
5. Restart your computer so that your changes to take effect.

Setting the Server Locale for Oracle

For development environments, Siebel eBusiness Applications support only binary collation sequencing. Therefore, when setting the locale for your development environment, either you must set NLS_SORT to BINARY or you must choose a Territory value that includes binary. In production environments, this restriction does not apply.

To set locale parameters and database sorting sequence

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

   The Edit String dialog box appears.

5. 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.
6. From the Task bar, click Edit > New > String Value.

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

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

   The Edit String dialog box reappears.

9. Type the appropriate collation sequence and click OK.

   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 Guidelines for Configuring the RDBMS.

10. Quit the Registry Editor.

Setting the Server Locale for 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 Guidelines for Configuring the RDBMS.

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