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