Difference between revisions of "COLLATE()"
From Recital Documentation Wiki
Helengeorge (Talk | contribs) (→Class) |
Helengeorge (Talk | contribs) |
||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
==Purpose== | ==Purpose== | ||
Function to translate character expression into its correct collating sequence | Function to translate character expression into its correct collating sequence | ||
| Line 26: | Line 24: | ||
==Products== | ==Products== | ||
| − | Recital | + | Recital Server, Recital |
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Functions]] | [[Category:Functions]] | ||
[[Category:Indexing]] | [[Category:Indexing]] | ||
[[Category:Indexing Functions]] | [[Category:Indexing Functions]] | ||
Latest revision as of 16:15, 27 November 2009
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 Server, Recital
