PostgreSQL 9.1devel(git 20100910) - ODBC driver 07.03.0100 bytea problem

From: Vladimir Kokovic <kokovic(dot)vladimir(at)gmail(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: PostgreSQL 9.1devel(git 20100910) - ODBC driver 07.03.0100 bytea problem
Date: 2010-09-12 14:13:00
Message-ID: AANLkTi=MT-LyUrL3RpB=XMfVGoos_hh8L+MnLjEErm8A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Hi,

In all versions up to version 9.1devel PostgreSQL, ODBC driver '07 .03.0100
'has worked well with fields of type bytea.

In the version of PostgreSQL 9.1devel, ODBC Driver '07 .03.0100 ' returns
greater length than length of the field,
ODBC Driver '08 .04.0200' returns the correct length of the field.

postgresql.conf
--------------------
#bytea_output = 'hex' # hex, escape
standard_conforming_strings = off

odbc-log-07.03.0100.log
--------------------------------
[ODBC][18205][SQLGetData.c][224]
Entry:
Statement = 0x8925b10
Column Number = 2
Target Type = -2 SQL_C_BINARY
Buffer Length = 4096
Target Value = 0x8928b38
StrLen Or Ind = 0xbfffe598
[ODBC][18205][SQLGetData.c][470]
Exit:[SQL_SUCCESS_WITH_INFO]
Buffer = [BINARYDATA...]
Strlen Or Ind = 0xbfffe598 -> 6641
DIAG [01004] The buffer was too small for the GetData.

odbc-log--08.04.0200.log
---------------------------------
[ODBC][18605][SQLGetData.c][224]
Entry:
Statement = 0x8933318
Column Number = 2
Target Type = -2 SQL_C_BINARY
Buffer Length = 4096
Target Value = 0x8938888
StrLen Or Ind = 0xbfffe598
[ODBC][18605][SQLGetData.c][470]
Exit:[SQL_SUCCESS]
Buffer = [BINARYDATA...]
Strlen Or Ind = 0xbfffe598 -> 3321

Best regards,
Vladimir Kokovic, DP senior, Belgrade, Serbia

Browse pgsql-odbc by date

  From Date Subject
Next Message Kilburn Abrahams 2010-09-13 04:35:21 Build problems with unixodbc 2.3
Previous Message Werner Kuhnle 2010-09-08 11:27:12 Re-4: Problem with simple SELECT over ODBC