My Oracle Support Banner

Filters Defined in ODI (Sunopsis) Integration Interface Against Chinese (Or Other Multibyte Character) Data from Microsoft SQL Server Function Incorrectly (Doc ID 424195.1)

Last updated on NOVEMBER 30, 2023

Applies to:

Oracle Data Integrator - Version 3.2.03.01 and later
Oracle Data Integrator on Marketplace - Version 1.0.2 and later
Information in this document applies to any platform.

Symptoms

In Oracle Data Integrator (ODI) (Sunopsis), it appears that there are some concerns with multibyte data processing on Microsoft SQL Server:

Examples:

Users can view and directly transfer Chinese (or other multibyte) data from Microsoft SQL Server but adding a Filter against the Chinese (or other multibyte) data in the Integration Interface appear to function incorrectly.

Note: this problem is uncommon in a single-language environment (when either Chinese or English is being used exclusively) and is only likely to occur in an environment where both languages are being used simultaneously.

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.