|Oracle9i OLAP Services Concepts and Administration Guide for Windows
Release 1 (9.0.1) for Windows
Part Number A90371-01
Localization, 7 of 9
The locale is the character set, language, and territory. The format for specifying this environment is language_territory.character set. For a list of valid keywords, refer to the following:
To specify the default values that apply to all sessions of a particular instance of OLAP Services, set the OLAP Services locale configuration parameters. Users can override the language and territory settings for their sessions.
NLS_LANG is a configuration parameter that identifies the locale for an instance of OLAP Services. The character set specified in NLS_LANG is the instance character set, and thus the analytic workspace character set for all workspaces created or upgraded using this instance. To set NLS_LANG, follow the guidelines in "Choosing an Instance Character Set".
The language and territory components are much less important since they are set on a session-by-session basis by client applications.
Be sure to test the new configuration by viewing text data in OLAP Services, preferably through the client applications that this instance is intended to support. If you see meaningless characters (such as boxes or question marks), then your choice of character set is incorrect.
The instance character set for a session is determined by the following rules:
For more information about configuration parameters, search for them by name in Instance Manager Help.