B Configuring Oracle Database Companion CD Globalization Support

This appendix describes the following Globalization Support topics:

Installing and Using Oracle Components in Different Languages
Configuring Locale and Character Sets with the NLS_LANG Parameter

B.1 Installing and Using Oracle Components in Different Languages

This section describes the following features:

Running Oracle Universal Installer in Different Languages
Using Oracle Components in Different Languages

B.1.1 Running Oracle Universal Installer in Different Languages

Oracle Universal Installer runs by default in the selected language of your operating system. You can run Oracle Universal Installer in the following additional languages:

Brazilian Portuguese
German
Japanese
Simplified Chinese
Traditional Chinese
French
Italian
Korean
Spanish

To run Oracle Universal Installer in a different language:

Change the language in which your operating system is running. For example, on Windows 2003:
1. From the Start menu, select Control Panel, then Regional and Language Options.
2. From the drop-down list, select a language from the preceding table list and choose OK.
Run Oracle Universal Installer by following the instructions in the Oracle Database Installation Guide for Microsoft Windows (x64).

Note:
The selected language is assigned to the NLS_LANG registry parameter.

B.1.2 Using Oracle Components in Different Languages

You can select other languages in which to use Oracle components (such as Oracle Net Configuration Assistant, and Database Configuration Assistant). Note that this does not change the language in which Oracle Universal Installer is run. For the Oracle component to run in the selected language, it must be the same as the language set for your operating system. You can change your operating system language in the Regional Settings window from the Control Panel.

To use components in different languages:

Start Oracle Universal Installer:
- From the installation media: From the installation media, navigate to the companion directory and double-click setup.exe.
- From an installed Oracle Database Companion CD: From the Start menu, select Programs, then Oracle - HOME_NAME, then Oracle Installation Products, then Universal Installer.
From the Select Installation Type window, select the Product Languages button.

The Language Selection window appears.
Select a language in which to use Oracle components from the Available Languages field.
Use the > arrow to move the language to the Selected Languages field and click OK.
Select appropriate products for installation and click Next.

After installation is complete, the dialog box wording, messages, and online help for the installed components display in the language you selected.

B.2 Configuring Locale and Character Sets with the NLS_LANG Parameter

Oracle provides Globalization Support that enables users to interact with a database in their preferred locale and character set settings. The NLS_LANG parameter specifies locale behavior for Oracle software. It sets the language and territory used by the client application and the database. It also sets the character set for entering and displaying data by a client program, such as SQL*Plus.

The NLS_LANG parameter is stored in the registry under the HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOMEID\NLS_LANG subkey, where ID is the unique number identifying the Oracle home. This parameter uses the following format:

NLS_LANG = LANGUAGE_TERRITORY.CHARACTER_SET

where:

Parameter	Description
`LANGUAGE`	Specifies the language and conventions for displaying messages, day name, and month name.
`TERRITORY`	Specifies the territory and conventions for calculating week and day numbers.
`CHARACTER_SET`	Specifies the encoding of the database client, which is the character set for data entered or displayed by a client program.

The following table lists some of the values for the NLS_LANG parameter:

Operating System Locale	NLS_LANG Values
French (France)	FRENCH_FRANCE.WE8ISO8859P15 FRENCH_FRANCE.WE8ISO8859P1 FRENCH_FRANCE.WE8MSWIN1252 FRENCH_FRANCE.AL32UTF8
Japanese (Japan)	JAPANESE_JAPAN.JA16EUC JAPANESE_JAPAN.JA16SJIS JAPANESE_JAPAN.AL32UTF8

Operating System Locale

NLS_LANG Values

French (France)

FRENCH_FRANCE.WE8ISO8859P15

FRENCH_FRANCE.WE8ISO8859P1

FRENCH_FRANCE.WE8MSWIN1252

FRENCH_FRANCE.AL32UTF8

Japanese (Japan)

JAPANESE_JAPAN.JA16EUC

JAPANESE_JAPAN.JA16SJIS

JAPANESE_JAPAN.AL32UTF8