About Database Sort Order in the Siebel Environment

Environments: Development, Test and Production.

Sort order (also called collation sequence) is specified during the initial installation of a database and defines the way in which the database sorts character data when executing queries. Sort order support depends on both the code page of the database and whether it is used in a development or a production environment:

• Development environments. For development databases, you must use a binary sort order due to the functional limitations of databases that use a nonbinary sort order.

• Production environments. For production databases, it is strongly recommended that you use binary sort order to prevent possible performance degradation.

The settings for binary sort order are unique for each database platform. For Siebel language support, Unicode support, and legacy code page support, see 1513102.1 (Article ID) on My Oracle Support.