COLLATE()

Purpose

Function to translate character expression into its correct collating sequence

Syntax

COLLATE(<expC>)

See Also

INDEX, SET LANGUAGE

Description

The COLLATE() function is used in conjunction with the SET LANGUAGE TO command for sorting or indexing. The SET LANGUAGE TO command allows use of foreign language character sets by using the character translation table specified in the "terminals" directory. The COLLATE() function then recognizes foreign characters and places the specified character expression, <expC>, correctly within the existing sequence. The COLLATE() function can translate and sort key expressions so that the INDEX ON command creates index files which include foreign characters.

Example

set language to french
use customers
index on collate(custname) to frenchcust

Products

Recital Server, Recital