IBM Support

Cannot process special UTF-8 characters using the Oracle Database adapter.

Troubleshooting


Problem

Cannot process special UTF-8 characters using the Oracle Database adapter.

Symptom

Cannot process special UTF-8 characters using the Oracle Database adapter.

Cause

The fields are defined as Native in the Type tree and the NLS_LANG environment variable is not set correctly.

Environment

Using IBM WebSphere Transformation Extender (WTX) Map with the Oracle Database Adapter to retrieve data that contains special characters.

Diagnosing The Problem

Retrieving special characters from an Oracle database the output is not as expected.


For example :

The Hungarian characters 'ř' and 'č' are 'r' and 'c' in the output.

Resolving The Problem

1, Change all Type Tree fields to be defined as UTF-16 from NATIVE.

2. The environment variable NLS_LANG must be set :

NLS_LANG=American_America.AL32UTF8

[{"Product":{"code":"SSVSD8","label":"IBM Transformation Extender"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"},{"code":"PF035","label":"z\/OS"}],"Version":"9.0.0.0;8.4.1.4;8.4.1.3;8.4.1.2;8.4.1.1;8.4.1.0;8.4.1;8.4.0.5;8.4.0.4;8.4.0.3;8.4.0.2;8.4.0.1;8.4.0.0;8.3.0.6;8.3.0.5;8.3.0.4;8.3.0.3;8.3.0.2;8.3.0.1;8.3.0.0","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Document Information

Modified date:
16 June 2018

UID

swg21984190

Page Feedback