|Oracle9i OLAP Services Concepts and Administration Guide
Release 1 (9.0.1)
Part Number A88755-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 database character set for all databases 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.
The NLS_CHARSET_OS parameter identifies the character set of the operating system when it is different from the character set identified in NLS_LANG. This setting allows OLAP Services to interact with the operating system to locate user files and persistent workspaces.
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.