Difference between revisions of "SET LANGUAGE"

From Recital Documentation Wiki
Jump to: navigation, search
 
(4 intermediate revisions by 2 users not shown)
Line 1: Line 1:
==Class==
 
Screen Environment
 
 
 
 
==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 Database Server, Recital Mirage Server, Recital Terminal Developer
+
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

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