Getting bytea results via SQLGetData - Mailing list pgsql-odbc

From Constantin S. Svintsoff
Subject Getting bytea results via SQLGetData
Date
Msg-id Pine.BSF.4.21.0101302003110.75349-200000@localhost
Whole thread Raw
List pgsql-odbc
Hi, there!

It seems there's a bug with fetching bytea (SQL_VARBINARY) columns via
SQLGetData() as SQL_C_CHAR, you always get zero-length result.
I'm using unixODBC-1.8.12, but that code is the same with code
of driver in postgres distribution.

In convert.c in function copy_and_convert_field there is a special case
for such a values, but it works improperly. Without this case, when
bytea data is processed as anything else everything seems to work fine.
Driver receives pretty good escaped data i think there is no need to do
something with it.

Here is a patch for convert.c.


/Constantin

Attachment

pgsql-odbc by date:

Previous
From: Dave Page
Date:
Subject: RE: Updated ODBC Driver Download
Next
From: Bruce Momjian
Date:
Subject: Re: [JDBC] Re: [INTERFACES] Postgresql and JDBC