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

Guidelines for Selecting a Language for MS SQL Server

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

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.

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 both on the code page of the database and on whether it will be used in a development or a production environment.

For more information on supported sort orders, see System Requirements and Supported Platforms on Siebel SupportWeb.

• Development environment databases. Repository object names in your development environment database must sort using binary sort order, because Siebel Tools uses this sort order internally.

  CAUTION:  When MS SQL Server is installed, the instance is set by default to dictionary sort order and, if this is 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. Consult your Microsoft documentation for instructions on setting this sort order.

  NOTE:  Binary sort order is the simplest and fastest sort order to perform in the database. Binary sorting is case-sensitive and based on the numeric values (for example, 0 through 255 for an 8-bit character set) of characters in the installed character set.

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

• Production environment databases. Also use binary sort order in production environment databases, for performance reasons. For information on production environment database restrictions, see System Requirements and Supported Platforms on Siebel SupportWeb. Also refer to your MS SQL Server documentation.