Siebel Server Installation Guide for Microsoft Windows > Creating the DB2 Universal Database for Windows and UNIX > Creating the Database >

Creating and Setting the Language Characteristics of Your Database

NOTE:  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 will run, 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 Sample Database Creation Scripts.

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

To look up the Siebel language code, territory, and codeset for your database, see System Requirements and Supported Platforms.


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.


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 will sort 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 available on SupportWeb.

Development Environment Databases

Repository object names in your development database must sort in the same order that they would under 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 is because in 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 available on SupportWeb.

NOTE:  You must make sure your data is exported and imported correctly.

To create your database

  1. See System Requirements and Supported Platforms for the values that apply to your language.
  2. Locate the primary(base) language your database will use, the territory for your language, and the applicable codeset.
  3. Using the DB2 UDB Command Line Processor, enter the following command:
  4. db2 create database dbname using codeset territory collate using identity


    dbname is the alias for your database.

    codeset is the textual representation of your code page.

    NOTE:  If you are installing a Unicode database, You must enter UTF-8 as the codeset and retain the hyphen. UTF-8 is the parameter used for Unicode implementation on DB2 although the actual processing will use UCS-2. This is because when you specify UTF-8 as the encoding for the VARCHAR type, the encoding for the VARGRAPHIC type is automatically set to UCS-2, even though the UCS-2 is not specified as the parameter.

    territory is the territory for the language your database runs in under that codeset.

 Siebel Server Installation Guide for Microsoft Windows 
 Published: 25 June 2003