Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

I can't get text column from PostgreSQL database via dg4odbc

2671659Jan 20 2015 — edited Jan 21 2015

Hi guys,

I have a database link to a PostgresPlus database using dg4odbc.

When selecting text type columns, I can't get the data of text type columns.

But in isql,I can get the data of text columns.

Postgres Database Table

CREATE TABLE edbuser.tc

(

id integer,

t1 text,

t2 text,

t3 character varying(20),

t4 text,

cmt character varying(20)

)

Query within isql and Prostgres

id	t1	t2	t3	t4	cmt
1	a	b	c	d	test1
2	aa	bb	cc	dd	test2

Executing SQL from Oracle to PostgreSQL Database

id	t3	cmt
1	c	test1
2	cc	test2

These text type columns are disappeared

Initialization File

HS_FDS_TRACE_LEVEL = 255

HS_FDS_CONNECT_INFO = Enterprisedb

HS_FDS_SHAREABLE_NAME = /usr/lib64/libodbc.so

HS_LANGUAGE=american_america.al32utf8

HS_NLS_NCHAR = UCS2

HS_FDS_SQLLEN_INTERPRETATION=64

set ODBCINI = /etc/odbc.ini

This post has been answered by Mkirtley-Oracle on Jan 21 2015

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 18 2015

Added on Jan 20 2015

#heterogeneous-connectivity

5 comments

2,965 views