Siebel Installation Guide for Microsoft Windows: Servers, Mobile Web Clients, Tools > Guidelines for Configuring the RDBMS > Creating the MS SQL Server Database >

Selecting a Language for the MS SQL Server Database

As part of database creation, you must set the language characteristics of your database, even if you deploy in only one language.

Sort Order

The sort order is a characteristic that requires special consideration regarding the Siebel Database. On MS SQL Server, the sort order of a database instance is specified during database creation and defines the way in which the instance will sort character data.

Although each SQL Server system database and each object within a database can have its own unique sort order, you should set the sort order at the database instance level only.

The Siebel application's support for a given sort order depends on both the code page of the database and whether it will be used in a development or a production environment.

Sort Order Setting in Development Environment Databases

Repository object names in your development environment database must sort using binary sort order. 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 on Siebel SupportWeb.

CAUTION:  When installing MS SQL Server, the instance is set by default to dictionary sort order and, if not changed, every database inherits this setting. The master database cannot be changed without rebuilding the instance. Therefore, it is strongly recommended that the instance sort order be set to binary at installation time. Please consult your Microsoft documentation for instructions on setting this sort order.

Sort Order Setting in Production Environment Databases

Use binary sort order in production databases as well for performance reasons. For information on production environment database restrictions, see System Requirements and Supported Platforms on Siebel SupportWeb.

Customers are responsible for making sure that their data is backed up and restored correctly.