DG4DRDA Char or Varchar String Truncated Due To Single Byte Multi Byte Conversion When Using Accented Characters (Doc ID 1475851.1)

Last updated on JANUARY 18, 2017

Applies to:

Oracle Database Gateway for DRDA - Version 11.2.0.2 and later
Information in this document applies to any platform.

Symptoms

VARCHAR column is truncated using DG4DRDA even if HS_NLS_LENGTH_SEMANTICS=CHAR and HS_KEEP_REMOTE_COLUMN_SIZE=LOCAL.

This occurs when using accented characters.

When selecting the col2 with accented chars, the result is truncated -
SQL> select col1, col2 from PROVA_ORACLE_DRDA@ujd0 where col1=2;
   COL1                                                                      
----------                                                        
COL2                                                                        
-----------------------------------------------------------------------------
         2
ìèéàòù$%AAAAAAAddddddddddddddddddddddddddddddkkkkkkkkkkkkkweopokpokpokjaaaaaab
bb
bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbasdfkaaaaahhheroifsdoirigje
ro
:
dddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddd
dd
dddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddd

When selecting the col1 with no accented chars, the result is not truncated -
SQL> select col1, col2 from PROVA_ORACLE_DRDA@ujd0 where col1=1;
   COL1                                                                      
----------                                                                  
COL2                                                                        
-----------------------------------------------------------------------------
         1
AAAAAAAAAAAAAAAddddddddddddddddddddddddddddddkkkkkkkkkkkkkweopokpokpokjaaaaaab
bb
bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbasdfkaaaaahhheroifsdoirigje
ro
:
dddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddd
dd
ddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddasda
sd

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