Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-odbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group