International Language, Character Set, and Local Settings for Harvest using Oracle.

Document ID : KB000055632
Last Modified Date : 14/02/2018
Show Technical Document Details

The following Oracle settings apply only to Oracle repositories and are required for international Harvest installations. Check the following:

Does Oracle support your language?
What character set should you use for Oracle?

A number of system tables and views use language settings in Oracle. Check these settings using the following SQL statements:

NLS_DATABASE_PARAMETERS - D efault set up for the database at creation:

     'select * from nls_database_parameters;'

NLS_INSTANCE_PARAMETERS - Parameters set in init SID .ora:

     'select * from nls_instance_parameters;'

NLS_SESSION_PARAMETERS - Parameters set by NLS_LANG or alter session
(does not include client character set):

     'select * from nls_session_parameters;'

V$NLS_PARAMETERS - Values of NLS parameters for current values:

     'select value from v$nls_parameters;'

V$NLS_VALID_VALUES - Values which can be used for CHARACTERSET, LANGUAGE, TERRITORY, and SORT (depending on what was loaded at installation time).

You may also want to adjust other Oracle NLS parameters such as NLS_CALENDER, NLS_DATE_FORMAT, and NLS_TERRITORY.

To ensure that your extended ASCII chars such as ?, ? ? or ? are stored correctly in Oracle, create your database with a character set which includes the characters  you want to display. For example, the Euro sign ? requires set WE8ISO8859P15, and Japanese double-byte characters require set JA16SJIS.

The above settings apply to the Oracle server. All oracle clients, including any harvest client machine, must have the corresponding NLS_LANG environment variable set correctly. Use the following syntax:

NLS_LANG=language.territory.character-set  

For example, to set this parameter for German on a UNIX or Linux machine, use the following:

NLS_LANG=GERMAN.GERMANY.WE8ISO8859P15

Then export the setting:

Export NLS_LANG

The following command is optional and simply displays the value used with each login:

Echo NLS_LANG=$NLS_LANG

On Windows, you must set this in the user environment variables.

Modifying Scripts or Profiles

This section describes how UNIX or Linux users can:

Add the NLS_LANG and related variables to the wrapper scripts in the HARVESTHOME\bin directory.

Add the NLS_LANG and related variables to their profiles.

Important! Users must perform one but do not need to perform both of these tasks

Modifying Scripts

The HARVESTHOME/bin directory contains scripts that set up the environment for running the various Harvest tools. These scripts are what are actually executed (not the Harvest tools directly), because the scripts call the tools.

To add the NLS_LANG variable to each of these scripts, follow these steps:

  1. Edit the $HARVESTHOME/install/harvest.app.sh file.

  2. Add the following lines to the file:
        NLS_LANG=language.territory.character-set
        export NLS_LANG
  3. Save the file and exit.

  4. Run the Harvest installation program $HARVESTHOME/install/install.sh and select Option 3 for maintenance.

  5. Answer all prompts and exit the program.