Difference between revisions of "COLLATE()"

From Recital Documentation Wiki
Jump to: navigation, search
(Class)
Line 1: Line 1:
==Class==
 
Indexing
 
  
  

Revision as of 14:50, 27 October 2009


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 Database Server, Recital Mirage Server, Recital Terminal Developer