Siebel Server Installation Guide for Microsoft Windows > Creating the Oracle Database > Creating the Database >

Creating the Language Characteristics of Your Database

When creating your database, you must specify the character set at the database level. You will specify other language characteristics at the database client level. For information about setting database client language parameters, see Installing the Siebel Database Server for Oracle.

You specify the character set of your Oracle database with the following command:



INSTANCE_NAME is the name of your Oracle instance.

CHARACTER_SET_NAME is the textual name of the character set you want to run; for example, WE8MSWIN1252.

NOTE:  National character does not concern Siebel installation because Siebel does not use the three datatypes, which can store data in the national character set (NCHAR, NVARCHAR2, NCLOB.) You should choose your own national character set.

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.

Development Environment Databases

Repository object names in your development database must sort using binary sort order. Siebel Tools uses this sort order internally. Otherwise, repository merges during future upgrades of the Siebel Database will fail. For more information on supported sort orders, see System Requirements and Supported Platforms, available on SupportWeb.

Production Environment Databases

For performance reasons, it is strongly recommended that you use binary sort order in production databases. For information on production environment database restrictions, see System Requirements and Supported Platforms, available on SupportWeb.

For information about setting the order in which your database sorts data, see NLS_SORT under Oracle Database Configuration Guidelines. For information about setting the NLS date format, see NLS_DATE_FORMAT within the same section.

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