ALLBASE/SQL lets you manipulate databases in a wide variety
of native languages in addition to the default language, known as n-computer.
You can use either 8-bit or 16-bit character data, as appropriate
for the language you select. In addition, you can always include
ASCII data in any database, because ASCII is a subset of each supported
character set. The collating sequence for sorting and comparisons
is that of the native language selected. A list of supported languages
is in /usr/lib/nls/config.
You can use native language characters in a wide variety of
places, including these:
Values stored in host variables for CHAR or VARCHAR data (but not as variable names)
If your system has the proper message files installed, ALLBASE/SQL
displays prompts, messages and banners in the language you select;
and it displays system dates and time according to local customs.
In addition, ISQL accepts responses to its prompts in the native language
selected. However, regardless of the native language used, the syntax
of ISQL and SQL statements--including punctuation--remains in ASCII.
In order to use a native language other than the default,
you must follow the steps below:
Make sure
your I/O devices support the character set you use.
Set the HP-UX environment variable LANG to the native language (LanguageName) you use. For the C shell, use the following command:
For the K shell, use the following command (no spaces before
or after the equals sign):
typeset -x LANG=LanguageName |
For the Bourne shell, use the following commands:
LANG = LanguageName
export LANG |
This language then becomes the current language.
(If LANG is not set, the current language is n-computer.)
When you create a DBEnvironment, use the
LANG = LanguageName option of the START DBE NEW statement to specify the language.
You can use native language characters in the DBEnvironment
name. If you do so, you must set the LANG environment variable to
the same language before you can connect to the DBEnvironment. To
avoid confusion, you are advised to use the same language for the DBEnvironment
that you use in the LANG variable. Resetting the LANG variable while you are connected to a DBEnvironment
has no effect on the current DBE session.
