Unicode Support

The adapter supports Unicode data in Netezza that has been configured with the NLS_CHARACTERSET parameter set to UTF8. You must set the NLS_LANG environment variable in the edastart file or in a separate shell file.

Note: Netezza Unicode data in NCHAR/NVARCHAR fields is supported when the reporting server is configured for Unicode.

Syntax: How to Set the Environment Variable for NLS_LANG

To set the NLS_LANG environment variable to support Unicode, use the following syntax

NLS_LANG = language_territory.characterset

where:

language: Is the selected language.
territory: Is the name of the country associated with the selected language.
characterset: Is the value of the NLS_CHARACTERSET variable that is set in the Netezza database. For Unicode, this is always UTF8.

Note: To take advantage of the adapter support for Unicode data, the Reporting Server must be configured with UTF-8 code page 65001.

For details, see Unicode Support in the Server Administration manual.

Top of page

Example: Setting the NLS_LANG Variable for American English UTF-8

For American English UTF-8, you would export the following variables:

export LANG=EN_US.UTF-8
export NLS_LANG=American_America.UTF8