My Oracle Support Banner

ODI Studio Shows Improper Turkish, Chirilic and Other Gregorian Characters when Used in the Code of KM and Procedure Steps (Doc ID 2370921.1)

Last updated on SEPTEMBER 08, 2023

Applies to:

Oracle Data Integrator - Version 11.1.1.3.0 and later
Oracle Data Integrator Cloud Service - Version 17.1.3 and later
Information in this document applies to any platform.

Symptoms

NOTE: In the images below and/or the attached document, user details / company name / address / email / telephone number represent a fictitious sample. Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

Oracle Data Integrator (ODI) Procedures and Knowledge Modules (KMs) code contain Turkish characters such as:

When querying this data from SQLPlus or SQLDeveloper, the correct Turkish characters are shown.

However, when showing the code of same Procedure or KM in ODI Studio > Designer, each of the Turkish accentuated characters gets replaced by a question mark (?):

Note the ODI Work Repository is stored in an Oracle 12.2.0.1 database with WE8ISO8859P9 character set.

Also note that the same Procedure and KM code correctly shows in ODI 10g and older versions. The behavior only affects ODI 11g and later versions.

Changes

 

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.