BI Publisher Teradata Data Source With Charset=UTF8 Appends Blank Spaces For CHAR Data Types (Doc ID 2216769.1)

Last updated on MARCH 29, 2017

Applies to:

BI Publisher (formerly XML Publisher) - Version 11.1.1.7.x to 11.1.1.7.x [Release 11.1]
Information in this document applies to any platform.

Symptoms

In order to enable French characters to display in BI Publisher, recently added the configuration 'charset=UTF8' in the BI Publisher Data Sources.

Sample Connection String : jdbc:teradata:///charset=UTF8

After the configuration, the French characters were displayed properly but the fields that have CHAR as Data Type have started displaying trial blank spaces in the report.

For example:

Consider the data type of field CHAR(4) and the data stored in ABCD.

The SQL Assistant displays 'ABCD', but BI Publisher displays as 'ABCD '.

The number of blank spaces appended is equal to the length of the CHAR data length.

There are reports that uses CHAR column as KEY column in Bursting.

Due to this issue the Bursting delivery is also failing.

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