Siebel Installation Guide for UNIX > Configuring the RDBMS > Configuring an IBM DB2 UDB Database for Siebel Applications >

Guidelines for Selecting a Language for DB2 UDB

This topic is part of Configuring an IBM DB2 UDB Database for Siebel Applications.

As part of database creation, you must set the language characteristics of your database, even if you deploy in only one language.

To do this, you must know in which of the Siebel-supported languages your database runs, the codeset your database uses, the territory for your language, and the sort order (also known as collation sequence) your users prefer.

For a DB2 UDB production environment database, you can use any sort order. For a development environment database, you must use binary (identity) sort order.

Setting the language characteristics of the database is part of the sample script in the DBSRVR_ROOT/DB2UDB directory.

For supported Siebel language codes, territories, and codesets for your database, see Siebel System Requirements and Supported Platforms on Oracle Technology Network.

See also Planning RDBMS Installation and Configuration and Specifying the Locale for Siebel Applications.

See also Verifying System Preferences and Other Settings for Database Code Page.


DB2 UDB distinguishes between a code page (also known as a character set) and a codeset. A codeset is defined as a textual string that describes the character encoding standard used for the database, whereas a code page is a numeric representation of the same standard.


The territory, or region, is a combination of the language and the locale; for example, French would be a language example, while Canada or France would be locales in which French is used with regional differences. So, an example of a territory is Canadian French.

Sort Order

The sort order is specified during the initial installation of a database and defines the way in which the database sorts character data. Sort order support depends on both the code page of the database and whether it will be used in a development or a production environment.

For more information on supported sort orders, see Siebel System Requirements and Supported Platforms on Oracle Technology Network.

  • Development environment databases. Repository object names in your development environment database must sort in the same order that they would under the UTF-16 binary sort order, because Siebel Tools uses this sort order internally.

    NOTE:  Binary sort order is the simplest and fastest sort order to perform in the database. Binary sorting is case-sensitive and based on the numeric values (for example, 0 through 255 for an 8-bit character set) of characters in the installed character set.

    Customers are responsible for making sure that their data is backed up and restored correctly.

  • Production environment databases. For information on production environment database restrictions, see Siebel System Requirements and Supported Platforms on Oracle Technology Network. Also refer to your IBM DB2 UDB documentation.
Siebel Installation Guide for UNIX Copyright © 2011, Oracle and/or its affiliates. All rights reserved. Legal Notices.