Siebel Installation Guide for Microsoft Windows > Configuring the RDBMS > Configuring an Oracle Database for Siebel Applications >

Guidelines for Selecting a Language for Oracle Database

This topic is part of Configuring an Oracle Database for Siebel Applications.

When creating your database, you must specify the character set at the database level. You specify other language characteristics at the database client level.

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.

To specify the character set of your database

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

  CREATE DATABASE INSTANCE_NAME CHARACTER SET CHARACTER_SET_NAME

  where:

  • INSTANCE_NAME = The name of your Oracle database 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 that can store data in the national character set (NCHAR, NVARCHAR2, NCLOB).

Sort Order and Date Format

Follow documented Oracle Database guidelines for client-level settings for the NLS_SORT and NLS_DATE_FORMAT parameters.