My Oracle Support Banner

Data Gets Truncated When Using Dg4odbc Version 11.2 With Compatible Set to 10.1 When Selecting From a RebBrick Database (Doc ID 1327394.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Server - Enterprise Edition - Version: 11.2.0.1 and later   [Release: 11.2 and later ]
Information in this document applies to any platform.

Symptoms


Using Oracle version 11.2.0.1 Database Gateway for ODBC  (DG4ODBC) and the Oracle Server , running on an AIX 6.1 64 bit platform which connects to a RedBrick database, the following occurs -

1. When compatible set to 10.1 -

- all data is returned correctly from the RedBrick database


SQL; desc test@wmt
Name Null? Type
----------------------------------------- -------- ----------------
PERIODKEY NUMBER(10)
PERIODLDESC CHAR(40)
PERIODSDESC CHAR(10)
PERIODLEVEL CHAR(7)
WKEND CHAR(10)
SEQNO NUMBER(5)
PERIODTAG CHAR(15)


SQL;Select * from test@wmt;

PERIODKEY PERIODLDESC PERIODSDES PERIODL
---------- ---------------------------------------- ---------- -------
WKEND SEQNO PERIODTAG
---------- ---------- ---------------
2009032104 1234567890123456789012345678901234567890 1234567890 1234567
1234567890 12345 123456789012345


2. When compatible set to 11.2

- some character datatypes from the same RedBrick database have the right most character truncated.


SQL;Select * from test@wmt;

PERIODKEY PERIODLDESC PERIODSDES PERIODL
---------- ---------------------------------------- ---------- -------
WKEND SEQNO PERIODTAG
---------- ---------- ---------------
2009032104 123456789012345678901234567890123456789 123456789 123456
123456789 12345 12345678901234

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!


In this Document
  Symptoms
  Cause
  Solution
  References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.