Getting bytea results via SQLGetData

From: "Constantin S(dot) Svintsoff" <cs(at)newst(dot)net>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Getting bytea results via SQLGetData
Date: 2001-01-30 14:25:22
Message-ID: Pine.BSF.4.21.0101302003110.75349-200000@localhost
Views: Raw Message | Whole Thread | Download mbox
Lists: 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.


Attachment Content-Type Size
convert.c.diff text/plain 1.3 KB

Browse pgsql-odbc by date

  From Date Subject
Next Message Bruce Momjian 2001-01-30 17:14:58 Re: [JDBC] Re: [INTERFACES] Postgresql and JDBC
Previous Message Dave Page 2001-01-28 21:21:22 RE: Updated ODBC Driver Download