Bookshelf Home | Contents | Index | Search | PDF |
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:
CREATE DATABASE
INSTANCE_NAME
CHARACTER SETCHARACTER_SET_NAME
where:
INSTANCE_NAME
is the name of your Oracle instance.
CHARACTER_SET_NAME
isthe 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, seeNLS_DATE_FORMAT
within the same section.
Bookshelf Home | Contents | Index | Search | PDF |
Siebel Server Installation Guide for Microsoft Windows Published: 25 June 2003 |