Difference between revisions of "SET LANGUAGE"
Yvonnemilne (Talk | contribs) |
Helengeorge (Talk | contribs) |
||
| (4 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
| − | |||
| − | |||
==Purpose== | ==Purpose== | ||
Specifies language | Specifies language | ||
| Line 12: | Line 8: | ||
==See Also== | ==See Also== | ||
| − | [[COLLATE()]], [[INDEX]] | + | [[COLLATE()]], [[INDEX]], [[SORT]] |
| Line 38: | Line 34: | ||
The character translation table for the specified language should be specified in the ’terminals’ directory in a filename equivalent to: | The character translation table for the specified language should be specified in the ’terminals’ directory in a filename equivalent to: | ||
| + | |||
<terminal-type>-<first-3-characters-of-language>.ncs | <terminal-type>-<first-3-characters-of-language>.ncs | ||
| + | |||
For example, the german translation table for the VT200 terminal can be found in the file: vt200-ger.ncs. | For example, the german translation table for the VT200 terminal can be found in the file: vt200-ger.ncs. | ||
| Line 50: | Line 48: | ||
==Products== | ==Products== | ||
| − | Recital | + | Recital |
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Commands]] | [[Category:Commands]] | ||
[[Category:Set_Commands|LANGUAGE]] | [[Category:Set_Commands|LANGUAGE]] | ||
| + | [[Category:Terminal Environment]] | ||
| + | [[Category:Terminal Environment Set Commands]] | ||
Latest revision as of 16:11, 23 November 2009
Purpose
Specifies language
Syntax
SET LANGUAGE TO <language-type>
See Also
Description
The SET LANGUAGE TO command specifies the language to be used in the COLLATE() function and also the collating sequence for SORT operations. The COLLATE() function recognizes foreign characters and places the specified character expression correctly within the existing sequence. On execution of the SET LANGUAGE TO command, the appropriate language translation table is loaded from the ’terminals’ directory. The following languages are supported:
- AMERICAN
- BELGIAN
- BRITISH
- CHINESE
- DANISH
- DUTCH
- FINNISH
- FLEMISH
- FRENCH
- GERMAN
- ITALIAN
- JAPANESE
- NORWEGIAN
- RUSSIAN
- SPANISH
- SWEDISH
The character translation table for the specified language should be specified in the ’terminals’ directory in a filename equivalent to:
<terminal-type>-<first-3-characters-of-language>.ncs
For example, the german translation table for the VT200 terminal can be found in the file: vt200-ger.ncs.
Example
set language to french use customers index on collate(custname) to frenchcust
Products
Recital
