Siebel Installation Guide for Microsoft Windows: Servers, Mobile Web Clients, Tools > Guidelines for Configuring the RDBMS > Creating DB2 UDB Database Objects >

Selecting a Language for DB2 UDB

As part of database creation, you must create and set the language characteristics of your database, even if you deploy in only one language. To do this, you must know which of the Siebel-supported languages your database runs, the codeset your database uses, the territory (also called the locale) for your language (such as Canadian French), and the collating sequence your users prefer.For production DB2 database servers, you can use any collating sequences, but, for development only, IDENTITY collating sequence is supported.

Setting the language characteristics of the database is part of the sample script in the SIEBEL_ROOT\dbsrvr\DB2UDB directory.

CAUTION:  When creating a Unicode-enabled database, make sure you set the parameter DB2_INDEX2BYTEVARLEN to ON, or your database creation will fail.

For supported Siebel language code, territory, and codeset for your database, see System Requirements and Supported Platforms on Siebel SupportWeb.

Codeset

DB2 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.

Territory

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.

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 System Requirements and Supported Platforms on Siebel SupportWeb.

Development Environment Databases. Repository object names in your development 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. Otherwise, repository merges during future upgrades of the Siebel Database will fail. This failure occurs because, in the UTF-16 binary sort order, codepoints U+E000 to U+FFFF sort after codepoints U+10000 to U+10FFFF, whereas, in Unicode codepoint order, they sort before. For information on production environment database restrictions, see System Requirements and Supported Platforms on Siebel SupportWeb.