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
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 |