Skip Headers

Oracle8i Server User's Guide
Release 3 (8.1.7) for Fujitsu Siemens Computers BS2000/OSD

Part Number A95463-01
Go To Table Of Contents
Contents
Go To Index
Index

Go to previous page Go to next page

7
National Language Support

This chapter describes the National Language Support available with Oracle8i Release 3 for Fujitsu Siemens Computers BS2000/OSD, with information about the following:

Character set tables, country and regional information (relating to date format, names of months, and so on) are dynamically loaded at execution time. This reduces the actual storage requirements, and allows new languages to be added in future without the need to re-link all applications.

The files containing character-set information are created in the current BS2000 userid. The names of these files have the following format:

O81NLS.LXnnnnn.NLB

These files are for internal use only. You should not make changes to them. If you need a character set, language, or territory code that is not present, contact your Oracle Customer Support Representative, who will be able to check if any updates are available.

User-defined character sets as documented in the Oracle8i Reference are not supported for this release.

Specifying a Language, Territory and Character Set

To choose the language, territory and character set you wish to work with, you have to carry out separate procedures for the Oracle Server and the supported Oracle Server utilities.

Oracle Server

For the Oracle Server, your Database Administrator sets the NLS_LANGUAGE and NLS_TERRITORY parameters in the initialization file(s) as described in the Oracle8i Reference.

Other Oracle Server Products

For the supported Oracle Server products, you can choose your language, territory and character set from within BS2000/OSD by setting the value of the ORAENV variable NLS_LANG. Set this environment variable as follows:

NLS_LANG = language_territory.characterset 

where:

language
is any supported language

territory
is any supported territory

characterset
is the character set required by your terminal

For example:

NLS_LANG=German_Germany.D8BS2000 

Supported Language Conventions

Oracle8i Release 3 for Fujitsu Siemens Computers BS2000/OSD provides support for language conventions, such as day and month names, for the following languages:

Supported Territories

Oracle Server National Language Support provides support for territory conventions, such as start day of the week, for the following territories:

Supported Character Sets

Oracle8i Release 3 supports the following character sets for servers and clients under BS2000/OSD:

Name Description Usage

US8BS2000

Siemens 9750-62 EBCDIC 8-bit

American

D8BS2000

Siemens 9750-62 EBCDIC 8-bit

German

F8BS2000

Siemens 9750-62 EBCDIC 8-bit

French

E8BS2000

Siemens 9750-62 EBCDIC 8-bit

Spanish

DK8BS2000

Siemens 9750-62 EBCDIC 8-bit

Danish

S8BS2000

Siemens 9750-62 EBCDIC 8-bit

Swedish

WE8BS2000

Siemens EBCDIC.DF.04-1 8-bit

West European (= ISO 8859/1)

CL8BS2000

Siemens EBCDIC.EHC.LC 8-bit

Latin/Cyrillic-1 (= ISO 8859/5)

WE8BS2000L5

Siemens EBCDIC.DF.04-9 8-bit

WE & Turkish (= ISO 8859/9)

EE8BS2000

Siemens EBCDIC.EHC.L2 8-bit

East European (= ISO 8859/2)

CE8BS2000

Siemens EBCDIC.DF.04-2 8-bit

Central European (= ISO 8859/2)

WE8BS2000E

Siemens EBCDIC.DF.04-F 8-bit

West European with Euro symbol
(= ISO 8859/15)

The character set WE8BS2000E should be used as database character set if you want to store the euro symbol in the database or if you want to use the euro symbol as the dual currency symbol.

In addition to these supported character sets, if you are connecting to Oracle Server installations with a non-BS2000 character set, those servers can use any of the character sets listed in Oracle8i Reference.

Location of Message Files

All message files are located in ORAMESG.LIB under the installation userid.

Linguistic Definitions

All the linguistic definitions listed in the "National Language Support" chapter of Oracle8i Reference are available.

Choosing Conversion Site

In order to balance the conversion overhead you can specify whether client or server do it. For more information see ORAENV-parameter NLS_CONVERSION in Appendix B.


Go to previous page Go to next page
Oracle
Copyright © 2001 Oracle Corporation.

All Rights Reserved.
Go To Table Of Contents
Contents
Go To Index
Index