Siebel Installation Guide for UNIX: Servers, Mobile Web Clients, Tools > Configuring the RDBMS > Configuring IBM DB2 UDB for Siebel Applications >
Guidelines for Selecting a Language for DB2 UDB
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 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 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 $SIEBEL_ROOT/dbsrvr/DB2UDB directory.
For supported Siebel language code, territory, and codeset for your database, see System Requirements and Supported Platforms on Siebel SupportWeb.
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.
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 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 System Requirements and Supported Platforms on Siebel SupportWeb. Also refer to your IBM DB2 UDB documentation.