Configuring Globalization Support

To display another language in iSQL*Plus, you must configure all three tiers. The following example is for Japanese using the Unicode (UTF-8) character set.

To use the UTF-8 character encoding for Japanese:

Web Browser - client tier:

1. Ensure you have a font available that supports the Unicode character set.

   Microsoft Language Packs and updates are available for Windows operating systems to provide international language support at:

   http://windowsupdate.microsoft.com/R712/v31site/x86/w98/en/thanksstart.htm

   or you can find information about Asian language support for Windows at:

   http://www.microsoft.com/windows/ie/features/ime.asp

   Netscape information about fonts, and font downloads to support international language sets can be found at:

   http://home.netscape.com/eng/intl/basics.html.

2. Change the character encoding in your web browser:

   For Microsoft Internet Explorer:

   1. Select Encoding from the View menu.

   2. Select Unicode (UTF-8).

   For Netscape Navigator:

   1. Select Character Set from the View menu.

   2. Click Unicode (UTF-8).

3. Set the fonts associated with the UTF-8 character encoding:

   For Microsoft Internet Explorer:

   1. Select Internet Options... from the Tools menu.

   2. Select the General tab in the Internet Options dialog box and click Fonts...

   3. Choose a language script and the web page (proportional) font and plain text (fixed-width) font to be used with it.

   4. You can install fonts and support for additional languages by selecting Windows Update on the Tools menu

   For Netscape Navigator:

   1. Select Preferences from the Edit menu.

   2. Select Fonts under Appearance.

   3. Choose Unicode from the Encoding dropdown list.

   4. Select the variable and fixed pitch fonts that support the Unicode character set from the Variable and Fixed Pitch dropdown lists.

Oracle HTTP Server - middle tier:

Set the Globalization Support variables you want in the Oracle HTTP Server operating system. Every iSQL*Plus session inherits this environment.

1. In Windows, open System from the Control Panel.

2. Create a new environment variable, NLS_LANG, with a value of Japanese_Japan.UTF8.

3. Restart the Oracle HTTP Server.

Oracle9i - database tier:

Create your Oracle9i database with the UTF8 character set.

Note: Some iSQL*Plus error messages are in English in this release. See your Oracle9i Globalization Support Guide for more information about Configuring Globalization Support.