Interactive Reporting Does Not Display Non-Latin Characters from Nvarchar2 Fields (Doc ID 1074632.1)

Last updated on AUGUST 08, 2016

Applies to:

Hyperion BI+ - Version: 9.2.0.0.00 to 11.1.1.3.00 - Release: 9.2 to 11.1
Hyperion Intelligence - Version: 8.5.0.0.00 to 8.5.0.2.00   [Release: 8.5 to 8.5]
Information in this document applies to any platform.
***Checked for relevance on 08-Feb-2012***

Symptoms

From Interactive Reporting (IR) Studio, you query an Oracle 10.2.0.1 database where the character set is defined as follows:

NLS_CHARACTERSET= WE8ISO8859P1

NLS_NCHAR_CHARACTERSET =AL16UTF16

You cannot retrieve Cyrillic characters from the NVARCHAR2 field.   They display as upside-down question marks.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms