Difference between revisions of "COLLATE()"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
| Line 31: | Line 31: | ||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Functions]] | [[Category:Functions]] | ||
| + | [[Category:Indexing]] | ||
| + | [[Category:Indexing Functions]] | ||
Revision as of 15:07, 2 June 2009
Class
Indexing
Purpose
Function to translate character expression into its correct collating sequence
Syntax
COLLATE(<expC>)
See Also
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
