SET LANGUAGE

Purpose

Specifies language

Syntax

SET LANGUAGE TO <language-type>

See Also

COLLATE(), INDEX, SORT

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