|Oracle® Database System Administration Guide
10g Release 2 (10.2.0.5) for IBM z/OS on System z
|PDF · Mobi · ePub|
This appendix documents the National Language Support (NLS) information specific to Oracle Database for z/OS. Information about the product-specific operation of language-specific features is provided in Oracle Database Globalization Support Guide.
The topics in this appendix include:
Oracle Database Globalization Support enables you to store, process, and retrieve data in native languages. National Language Support (NLS) is a subset of globalization support. It enables Oracle applications to interact with users in their native language, using their specific cultural conventions for displaying data.
The Oracle NLS architecture is data-driven, enabling support for specific languages and character encoding schemes to be added without requiring any changes in source code.
Oracle error messages have been translated into 27 languages. Oracle Database for IBM z/OS on System z, Oracle Access Manager for CICS, and Oracle Access Manager for IMS include messages that are unique to IBM z/OS on System z. The following table lists the languages that are supported, their abbreviations, and their availability on IBM z/OS on System z:
|Language||Abbreviation||Availability of z/OS-Specific Messages|
Note:Operating System Dependent Interface messages are available in English only. These messages can be identified by the prefixes MIC, MIN, MIR, and MIS.
Oracle automatically converts these types of data as they transfer between client and server, if required:
CHAR, VARCHAR, and LONG database columns
SQL and PL/SQL statements
host variables containing character data
Both the client and the server have associated character sets. The client declares its character set before connecting to the server through the NLS_LANG environment variable. On z/OS, this parameter is in the ORA$ENV DD statement.
If NLS_LANG is not specified, the default character set is assigned.
The character set for the server is declared when a database is created in Oracle and it cannot be changed once established. The default database character set is assigned if one is not explicitly declared.
When the client character set matches the server character set, character data is sent between client and server without any conversion. If the two character sets differ, all character data is converted from one character set to the other as it is transferred. It is important to be aware that all data contained in a database, whether in user-specified tables or in Oracle-specified data dictionary tables, is stored in the database character set.
The character set in which the data is stored in the Oracle database is specified in the CHARACTER SET clause of the CREATE DATABASE statement. Refer to Oracle Database Administrator's Guide for more information about the CREATE DATABASE statement.
When creating a database, the character set you choose depends on the language(s) to be supported and the character set(s) of the clients connecting to the server. Many languages can be supported by the default z/OS character set of WE8EBCDIC1047, but many others cannot.
The following table enables to select an appropriate value for the CHARACTER SET clause of the CREATE DATABASE statement, based on the language to be supported and on the character set of the z/OS client. If you need to support languages that are not on this chart, contact Oracle Support Services.
|Language||Client Character Set on z/OS||Server Character Set on z/OS|
Footnote 1 Server character sets CL8EBCDIC1025S (Cyrillic) and EL8EBCDIC875S (Greek) on z/OS have some errors. Oracle recommends converting from those character sets to CL8EBCDIC1025R and EL8EBCDIC875R, respectively.
The client character set is determined by the data that is sent to the Oracle server. This is typically determined by the type of terminal that is used by the client. See your system administrator for more information about the character set used by your terminal.
The following character sets are supported for z/OS clients:
|AR8EBCDICX||XBASIC Code Page 420 Arabic|
|BLT8EBCDIC1112||EBCDIC Code Page 1112 Baltic/Multilingual|
|CL8EBCDIC1025||EBCDIC Code Page 1025 Cyrillic/Multilingual|
|D8EBCDIC273||EBCDIC Code Page 273 Austrian /German|
|DK8EBCDIC277||EBCDIC Code Page 277 Danish|
|EE8EBCDIC870||EBCDIC Code Page 870 East European|
|EL8EBCDIC875||EBCDIC Code Page 875 Greek|
|F8EBCDIC297||EBCDIC Code Page 297 French|
|I8EBCDIC280||EBCDIC Code Page 280 Italian|
|IW8EBCDIC424||EBCDIC Code Page 424 Hebrew|
|JA16DBCS||EBCDIC DBCS Japanese|
|KO16DBCS||EBCDIC DBCS Korean|
|S8EBCDIC278||EBCDIC Code Page 278 Swedish|
|TH8TISEBCDIC||EBCDIC Code Page 838 Thai|
|TR8EBCDIC1026||EBCDIC Code Page ISO 8859 Turkish|
|WE8EBCDIC37||EBCDIC Code Page 37 West European|
|WE8EBCDIC37C||EBCDIC Code Page 37 West European with extensions|
|WE8EBCDIC284||EBCDIC Code Page 284 Spanish (Spain)|
|WE8EBCDIC285||EBCDIC Code Page 285 English, UK|
|WE8EBCDIC500||EBCDIC Code Page 500 West European|
|WE8EBCDIC871||EBCDIC Code Page 871 Icelandic|
|WE8EBCDIC1047||EBCDIC Code Page 1047 Latin 1/Open Systems|
|WE8EBCDIC1140||EBCDIC code page 1140 Western European with Euro support|
|WE8EBCDIC1140C||EBCDIC code page 1140 Western European with extensions and Euro support|
|ZHS16DBCS||EBCDIC DBCS Simplified Chinese|
|ZHT16DBCS||EBCDIC DBCS Traditional Chinese|
The LXEGEN utility is used to customize calendar data, as described in Oracle Database Globalization Support Guide. Customizing calendar data is done primarily through z/OS UNIX System Services. You must be familiar with z/OS UNIX System Services in general, and the material in Oracle Database User's Guide for IBM z/OS describing the particular environment variables required by Oracle products in a z/OS UNIX System Services shell environment.
The z/OS implementation of Oracle products uses the same filenames and directory structure that the Oracle product documentation uses. Log on to z/OS UNIX System Services and verify that you can locate the applicable directories and files. If you have any difficulty locating these files, ensure that the ORACLE_HOME environment value is properly set and that z/OS UNIX System Services is properly installed before attempting to customize your calendar data.