DRDA Gateway 11.2 Wrongly Reports the Length of CHAR/VARCHAR Content When Using An Oracle Rdbms With Al32utf8 Character Set (Doc ID 1265964.1)

Last updated on SEPTEMBER 12, 2012

Applies to:

Oracle Database Gateway for DRDA - Version 11.2.0.1 to 11.2.0.1 [Release 11.2]
Information in this document applies to any platform.

Symptoms

Having on the DB2 side a table with a column char(1) and inserting the character 'a' reports as length 3 whereas having in this column the value '�' reports the length 2:
select col1,length(col1),substr(dump(col1,16),1,20),to_char(' ') as TG4DB2 from kgr1111@DRDA_11_2_0_1;

COL1 LENGTH(COL1) SUBSTR(DUMP(COL1,16),1,20) TG4DB2
---- ---------------------- -------------------------- ------
a       3                        Typ=96 Len=3: 61,20,
�       2                        Typ=96 Len=3: c3,a4,

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