Siebel Installation Guide for UNIX: Servers, Mobile Web Clients, Tools > Guidelines for Configuring the RDBMS > Creating Oracle Database Objects >

Selecting a Language for Oracle

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

To specify character set of your database

• Run the following command to specify character set for your database:

  CREATE DATABASE INSTANCE_NAME CHARACTER SET CHARACTER_SET_NAME

  where:

  INSTANCE_NAME = The name of your Oracle instance

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

National character sets are not required for Siebel installation because the Siebel application does not use the three data types, which can store data in the national character set (NCHAR, NVARCHAR2, NCLOB.)

Sort Order and Date Format

Follow Oracle's guidelines for client-level settings for the NLS_SORT and NLS_DATE_FORMAT parameters.