Oracle7 Getting Started for Windows NT Go to Product Documentation Library
Library
Go to books for this product
Product
Go to Contents for this book
Contents
Go to Index
Index



Go to previous file in sequence Go to next file in sequence

National Language Support



NLS_LANG Parameters and Components

The Oracle7 Server for Windows NT provides NLS that enables users to interact with the database in their selected language. When you install Oracle7 Server for Windows NT, you select a language for database messages. The Oracle Installer supplies a value for the NLS_LANG parameter to specify the language selected.

The NLS_LANG parameter uses the following format:

NLS_LANG = language_territory.character_set 
where:

language

Specifies the language and its conventions for displaying messages, day name, and month name.

territory

Specifies the territory and its conventions for calculating week and day numbers.

character_set

Controls the character set used for displaying messages.

The default language at installation is American English. If you accept the default language, the following value is supplied for the NLS_LANG parameter:

AMERICAN_AMERICA.WE8ISO8859P1

The NLS_LANG parameter is stored in the Windows NT Registry under: \HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\NLS_LANG.

Additional Information
See Oracle7 Server Reference for information on the NLS_LANG parameter and NLS initialization parameters.

Default Values for NLS_LANG

The following table lists the default NLS_LANG values for the languages selected during installation of Oracle7 Server for Windows NT.

Language NLS_LANG Value
Arabic

ARABIC_UNITED ARAB EMIRATES.AR8MSWIN1256

Brazilian Portuguese

BRAZILIAN PORTUGUESE_BRAZIL.WE8ISO8859P1

Czech

CZECH_CZECH REPUBLIC.EE8MSWIN1250

Danish

DANISH_DENMARK.WE8ISO8859P1

Dutch

DUTCH_THE NETHERLANDS.WE8ISO8859P1

English

AMERICAN_AMERICA.WE8ISO8859P1

Finnish

FINNISH_FINLAND.WE8ISO8859P1

French

FRENCH_FRANCE.WE8ISO8859P1

German

GERMAN_GERMANY.WE8ISO8859P1

Greek

GREEK_GREECE.EL8MSWIN1253

Hebrew

HEBREW_ISRAEL.IW8MSWIN1255

Hungarian

HUNGARIAN_HUNGARY.EE8MSWIN1250

Italian

ITALIAN_ITALY.WE8ISO8859P1

Japanese

JAPANESE_JAPAN.JA16SJIS

Korean

KOREAN_KOREA.KO16KSC5601

Norwegian

NORWEGIAN_NORWAY.WE8ISO8859P1

Polish

POLISH_POLAND.EE8MSWIN1250

Portuguese

PORTUGUESE_PORTUGAL.WE8ISO8859P1

Russian

RUSSIAN_CIS.CL8MSWIN1251

Simplified Chinese

SIMPLIFIED CHINESE_CHINA.ZHS16CGB231280

Slovak

SLOVAK_SLOVAKIA.EE8MSWIN1250

Spanish

SPANISH_SPAIN.WE8ISO8859P1

Swedish

SWEDISH_SWEDEN.WE8ISO8859P1

Traditional Chinese

TRADITIONAL CHINESE_TAIWAN.ZHT16BIG5

Turkish

TURKISH_TURKEY.WE8ISO8859P9

NLS Initialization Parameters

NLS can also be set by the database instance using the following initialization file parameters.

The NLS initialization parameters set NLS information specific to a database session or instance.

NLS_LANGUAGE

Any of the language values in the section "Language, Territory and Character Set Parameter Lists" in this appendix can be used for the NLS_LANGUAGE parameter.

NLS_TERRITORY

Any of the territory values in the section "Language, Territory and Character Set Parameter Lists" in this appendix can be used for the NLS_TERRITORY parameter.

Using ALTER SESSION

To set the language for a single Server Manager session, define NLS_LANGUAGE and NLS_TERRITORY with the command:

SRVMGR> ALTER SESSION SET NLS_LANGUAGE = language NLS_TERRITORY = territory 
where language and territory correspond to values listed in the section, "Language, Territory and Character Set Parameter Lists". This changes the language only for that Server Manager session.

Additional Information
See Oracle7 Server Reference for more information on NLS.

NLS_SORT

The value for the NLS_SORT initialization parameter is dependent on the language selected for the database instance. Oracle7 Server Reference contains information on all available NLS initialization parameters.

Language, Territory and Character Set Parameter Lists

The following tables include all possible settings for the supported languages, territories, and character sets for Oracle7 Server for Windows NT. Use these values independently within the NLS_LANG configuration parameter or use the language parameter to set the default values for territory and character set. Additionally, the language and territory values listed can be used in the initialization parameters NLS_LANGUAGE and NLS_TERRITORY.

Languages

AMERICAN

ARABIC

BENGALI

BRAZILIAN PORTUGUESE

BULGARIAN

CANADIAN FRENCH

CATALAN

CROATIAN

CZECH

DANISH

DUTCH

EGYPTIAN

ENGLISH

ESTONIAN

FINNISH

FRENCH

GERMAN

GERMAN DIN

GREEK

HEBREW

HUNGARIAN

ICELANDIC

INDONESIAN

ITALIAN

JAPANESE

KOREAN

LATIN AMERICAN SPANISH

LATVIAN

LITHUANIAN

MALAY

MEXICAN SPANISH

NORWEGIAN

POLISH

PORTUGUESE

ROMANIAN

RUSSIAN

SIMPLIFIED CHINESE

SLOVAK

SLOVENIAN

SPANISH

SWEDISH

THAI

TRADITIONAL CHINESE

TURKISH

UKRAINIAN

VIETNAMESE

Territories

ALGERIA

AMERICA

AUSTRIA

BAHRAIN

BANGLADESH

BRAZIL

BULGARIA

CANADA

CATALONIA

CHINA

CIS

CROATIA

CYPRUS

CZECH REPUBLIC

CZECHOSLOVAKIA

DENMARK

DJIBOUTI

EGYPT

ESTONIA

FINLAND

FRANCE

GERMANY

GREECE

HONG KONG

HUNGARY

ICELAND

INDONESIA

IRAQ

ISRAEL

ITALY

JAPAN

JORDAN

KOREA

KUWAIT

LATVIA

LEBANON

LIBYA

LITHUANIA

MALAYSIA

MAURITANIA

MEXICO

MOROCCO

NORWAY

OMAN

POLAND

PORTUGAL

QATAR

ROMANIA

SAUDI ARABIA

SLOVAKIA

SLOVENIA

SOMALIA

SPAIN

SUDAN

SWEDEN

SWITZERLAND

SYRIA

TAIWAN

THAILAND

THE NETHERLANDS

TUNISIA

TURKEY

UKRAINE

UNITED ARAB EMIRATES

UNITED KINGDOM

VIETNAM

YEMEN

Single-Byte Character Sets

AR8ADOS710

AR8ADOS710T

AR8ADOS720

AR8ADOS720T

AR8APTEC715

AR8APTEC715T

AR8ARABICMAC

AR8ARABICMACS

AR8ARABICMACT

AR8ASMO708PLUS

AR8ASMO8X

AR8HPARABIC8T

AR8ISO8859P6

AR8MSAWIN

AR8MSWIN1256

AR8MUSSAD768

AR8MUSSAD768T

AR8NAFITHA711

AR8NAFITHA711T

AR8NAFITHA721

AR8NAFITHA721T

AR8SAKHR706

AR8SAKHR707

AR8SAKHR707T

BG8MSWIN

BG8PC437S

BLT8CP921

BLT8MSWIN1257

BLT8PC775

BN8BSCII

CDN8PC863

CH7DEC

CL8ISO8859P5

CL8KOI8R

CL8MACCYRILLIC

CL8MACCYRILLICS

CL8MSWIN1251

D7DEC

D7SIEMENS9780X

DK7SIEMENS9780X

E7DEC

E7SIEMENS9780X

EE8ISO8859P2

EE8MACCE

EE8MACCES

EE8MACCROATIAN

EE8MACCROATIANS

EE8MSWIN1250

EE8PC852

EEC8EUROASCI

EEC8EUROPA3

EL8DEC

EL8ISO8859P7

EL8MACGREEK

EL8MACGREEKS

EL8MSWIN1253

EL8PC437S

EL8PC737

EL8PC851

EL8PC869

ET8MSWIN923

F7DEC

F7SIEMENS9780X

HU8ABMOD

HU8CWI2

I7DEC

I7SIEMENS9780X

IN8ISCII

IS8MACICELANDIC

IS8MACICELANDIC

IS8PC861

IW7IS960

IW8ISO8859P8

IW8MACHEBREW

IW8MACHEBREWS

IW8MSWIN1255

IW8PC1507

LA8ISO6937

LA8PASSPORT

LT8MSWIN921

LT8PC772

LT8PC774

LV8PC1117

LV8PC8LR

LV8RST104090

N7SIEMENS9780X

N8PC865

NDK7DEC

NE8ISO8859P10

NEE8ISO8859P4

NL7DEC

RU8BESTA

RU8PC855

RU8PC866

S7DEC

S7SIEMENS9780X

SE8ISO8859P3

SF7ASCII

SF7DEC

TH8MACTHAI

TH8MACTHAIS

TH8TISASCII

TR7DEC

TR8DEC

TR8MACTURKISH

TR8MACTURKISHS

TR8MSWIN1254

TR8PC857

US7ASCII

US8NOOP

US8PC437

VN8VN3

WE8DEC

WE8DG

WE8HP

WE8ISO8859P1

WE8ISO8859P9

WE8ISOICLUK

WE8MACROMAN8

WE8MACROMAN8S

WE8MSWIN1252

WE8NCR4970

WE8NEXTSTEP

WE8PC850

WE8PC860

WE8ROMAN8

YUG7ASCII

Multi-Byte Character Sets

AL24UTFFSS

JA16EUC

JA16MACSJIS

JA16SJIS

JA16TSTSET

JA16TSTSET2

JA16VMS

KO16KSC5601

KO16KSCCS

ZHS16CGB231280

ZHS16GBK

ZHS16MACCGB231280

ZHT16BIG5

ZHT16CCDC

ZHT16DBT

ZHT32EUC

ZHT32SOPS

ZHT32TRIS

Installing Additional Languages

To install an additional language for your Oracle7 Server for Windows NT (for example, to specify different NLS information for different instances), you must install the language files for that language directly to your Oracle7 Server for Windows NT directories. If you installed Oracle7 Server for Windows NT from the CD-ROM, you can install additional languages by directly copying the complete set of language files for that language from the CD-ROM disc.

Copy the following files from the CD-ROM disc to the ORANT subdirectories indicated in the following table. In the file names, x represents the abbreviation for the desired message language. In the directory names, nn represents the version of the product installed. The language file abbreviations are listed in the Language File Abbreviations table later in this appendix.

Copy from CD-ROM... To this Directory
DBVx.MSB

EXPx.MSB

IMPx.MSB

MGRx.MSB

ULx.MSB

LCDx.MSB

ORAx.MSB

SOSDx.MSB

OPWx.MSB

ORANT\RDBMSnn

ORANT\RDBMSnn

ORANT\RDBMSnn

ORANT\RDBMSnn

ORANT\RDBMSnn

ORANT\RDBMSnn

ORANT\RDBMSnn

ORANT\RDBMSnn

ORANT\RDBMSnn

NCRx.MSB

NLx.MSB

NLTx.MSB

NMPx.MSB

NMRx.MSB

NMSx.MSB

NNCx.MSB

NNFx.MSB

NNLx.MSB

NPLx.MSB

OSNx.MSB

SNLx.MSB

TNSx.MSB

ORANT\DBS

ORANT\DBS

ORANT\DBS

ORANT\DBS

ORANT\DBS

ORANT\DBS

ORANT\DBS

ORANT\DBS

ORANT\DBS

ORANT\DBS

ORANT\DBS

ORANT\DBS

ORANT\DBS

PCMx.MSB

PLSx.MSB

PXx.MSB

ORANT\PLSQLnn

ORANT\PLSQLnn

ORANT\PLSQLnn

SQLx.MSB

ORANT\PROnn

SPWx.MSB

ORANT\PLUSnn

EPCx.MSB

ORANT\OTRACEnn

Language Abbreviation
AMERICAN

US

ARABIC

AR

BENGALI

BN

BRAZILIAN PORTUGUESE

PTB

BULGARIAN

BG

CANADIAN FRENCH

FRC

CATALAN

CA

CROATIAN

HR

CZECH

CS

DANISH

DK

DUTCH

NL

EGYPTIAN

EG

ENGLISH

GB

ESTONIAN

ET

FINNISH

SF

FRENCH

F

GERMAN

D

GERMAN DIN

DIN

GREEK

EL

HEBREW

IW

HUNGARIAN

HU

ICELANDIC

IS

INDONESIAN

IN

ITALIAN

I

JAPANESE

JA

KOREAN

KO

LATIN AMERICAN SPANISH

ESA

LATVIAN

LV

LITHUANIAN

LT

MALAY

MS

MEXICAN SPANISH

ESM

NORWEGIAN

N

POLISH

PL

PORTUGUESE

PT

ROMANIAN

RO

RUSSIAN

RU

SIMPLIFIED CHINESE

ZHS

SLOVAK

SK

SLOVENIAN

SL

SPANISH

E

SWEDISH

S

THAI

TH

TRADITIONAL CHINESE

ZHT

TURKISH

TR

UKRAINIAN

UK

VIETNAMESE

VN

Language File Abbreviations

For example, the following list is the complete set of German language files:

OPWD.MSB

EXPD.MSB

IMPD.MSB

MGRD.MSB

ULD.MSB

EPCD.MSB

LCDD.MSB

ORAD.MSB

PCMD.MSB

PLSD.MSB

PXD.MSB

SOSDD.MSB

SQLD.MSB

CPYD.MSB

SP1D.MSB

SP2D.MSB

SPWD.MSB

NCRD.MSB

NLD.MSB

NLTD.MSB

NMPD.MSB

NMRD.MSB

NMSD.MSB

NNCD.MSB

NNFD.MSB

NNLD.MSB

NPLD.MSB

OSND.MSB

SNLD.MSB

TNSD.MSB

DVBD.MSB



Go to previous file in sequence Go to next file in sequence
Prev Next
Oracle
Copyright © 1996 Oracle Corporation.
All Rights Reserved.
Go to Product Documentation Library
Library
Go to books for this product
Product
Go to Contents for this book
Contents
Go to Index
Index