Bookshelf Home | Contents | Index | PDF     

Siebel Search Administration Guide > Administration of Siebel Search > Search Execution Settings >

Collation Sequence Setting

This setting specifies the name of a collation function that is used to determine the ordering of character strings. The default collation sequence provides dictionary ordering for English and French text being returned by most languages based on Latin 1.

Example

Property: Collation Sequence

Value: DICTIONARY_LATIN1

In Windows 32-bit environments, the following collation sequences are included in the fultext.ftc system configuration file. You can use any of them by specifying the name in the SET COLLATION_SEQUENCE statement. They all require that their respective locale be installed on the Windows system.

All supported locales are listed below.

n AFRIKAANS
n BASQUE
n CATALAN
n DANISH
n DUTCH
n DUTCH_BELGIAN
n ENGLISH_USA
n ENGLISH_UK
n ENGLISH_CANADIAN
n ENGLISH_NEW_ZEALAND
n ENGLISH_AUSTRALIAN
n ENGLISH_IRELAND
n ENGLISH_SOUTH_AFRICAN
n FINNISH
n FRENCH
n FRENCH_BELGIAN
n FRENCH_SWISS
n FRENCH_CANADIAN
n FRENCH_LUXEMBOURG
n GERMAN
n GERMAN_SWISS
n GERMAN_AUSTRIAN
n GERMAN_LUXEMBOURG
n GERMAN_LIECHTENSTEIN
n ICELANDIC
n INDONESIAN
n ITALIAN
n ITALIAN_SWISS
n JAPAN_EUC
n JAPAN_SJS
n JAPAN_UTF8
n KOREA_87
n KOREA_UTF8
n NORWEGIAN_BOKMAL
n NORWEGIAN_NYNORSK
n PORTUGUESE
n PROTUGUESE_BRAZILIAN
n SPANISH_MEXICAN
n SPANISH
n SPANISH_MODERN
n SWEDISH

 

To create collation sequence setting

  1. Navigate to Search Administration > Basic Settings.
  2. From the Setting Properties menu, select New Record.

    A new row appears in the Setting Properties list.

  3. Click in the Name column of the new row, and from the drop-down list, select Collation Sequence.
  4. Click in the Value column of the new row, and in the text box, enter the Dictionary value, and then step off the record to save it.
    
Siebel Search Administration Guide