Siebel Global Deployment Guide > Overview of Global Deployments >

About the Database Collation Sequence

The collation sequence, also called sort order, is the ordering relationship, or sequence, between data records. Each database has a collation sequence so that records returned by queries can be returned in a certain order, such as an alphabetic order for text strings. The collation sequence determines the order in which records are displayed in the Siebel client, most noticeably in list views.

A collation sequence is defined when you set up the Siebel database. All of the sorting is done in the Siebel database by the database server. Sorting is not set or performed within the Siebel application and does not depend on the operating system.

NOTE:  For more information about creating and configuring the Siebel database, see the Siebel Installation Guide for the operating system you are using. For more information about collation sequences for upgrade environments, see Siebel Database Upgrade Guide.

For the collation sequences supported for each supported RDBMS platform for the Siebel database, see the Certifications tab on My Oracle Support. For a list of the languages supported by Siebel Business Applications, and the supported code pages for each database, see 1513102.1 (Article ID) on My Oracle Support. Also consult your RDBMS vendor documentation.

The collation sequence in effect for a database is determined by one of the following implementation methods:

• Indexes created in the Siebel database provide a default collation sequence. In Oracle Database, indexes always use binary collation sequence.
• Post-query sorting might also be supported for an RDBMS platform. However, this method of sorting yields slower performance and requires all of the records to have been retrieved first. For this reason, it is impractical for Siebel applications, which always perform open-ended queries.

For the development environment, only binary collation sequence is supported. For a production environment, you can specify the collation sequence most suitable for your deployment.

NOTE:  Changing the collation sequence after the Siebel database has been installed requires rebuilding your indexes. On a fully loaded production database, this task is time-consuming and database resource-intensive. For help with planning a project of this complexity, it is recommended to engage Oracle's Application Expert Services. Contact your Oracle sales representative for Oracle Advanced Customer Services to request assistance from Oracle's Application Expert Services.

Which collation sequence is best for your deployment depends on factors such as RDBMS support, performance requirements, database availability requirements, the code page in use, the needs of your users, and the nature of the data that is to be retrieved by different groups of users.

Binary collation sequence offers the best performance and does not require you to rebuild your indexes for the production environment. This collation sequence works well for users working with English-language data, because the ASCII character set is based on the English alphabet and corresponds to the binary collation sequence. However, sorting might be unsuitable for users and data in languages other than English.

For multilingual deployments using Unicode, a linguistic collation sequence based on the Unicode Collation Algorithm (UCA), which goes by different names for different RDBMS vendors, might be a suitable collation sequence. UCA, also known as ISO 14651, provides reasonably good results with mixed-language data.

Other linguistic, or dictionary, collation sequences might offer optimal sorting results for particular languages or groups of languages. Such collation sequences might be suitable for certain deployments, such as those requiring compatibility with the CP932 (Japanese Shift-JIS) sort order.

Linguistic collation sequences that are not based on UCA might associate multiple characters (such as accented and unaccented versions of a particular letter) so they will be treated the same for sorting purposes, but will also be treated the same in unique indexes. If you are changing to a case- or accent-insensitive collation sequence, then you will need to first clean out any data that is unique only due to a case or accent difference.

Database Collation for the Local Database

As of Siebel Innovation Pack 2016, database collation for the Siebel Mobile Web Client, for which the local database uses Oracle Database XE, is the same as for Oracle Database Enterprise Edition.

A local database used for development with Siebel Tools must use the binary collation sequence. Using Siebel Tools against a non-binary collation sequence is not supported.