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

am 12.09.2010 16:13:00 von Vladimir Kokovic

--e0cb4e7004cfcb70c804901093d6
Content-Type: text/plain; charset=ISO-8859-1

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

--e0cb4e7004cfcb70c804901093d6
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Hi,

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

In the version of PostgreSQL 9.1de=
vel, ODBC Driver '07 .03.0100 ' returns greater length than length =
of the field,

ODBC Driver '08 .04.0200' returns the correct length of the fi=
eld.

postgresql.conf

-----------=
---------

#bytea_output =3D 'hex' =A0 =A0 =A0 =A0 =A0 =A0=
# hex, escape

standard_conforming_strings =3D off

odbc-log-=
07.03.0100.log

--------------------------------

[ODBC][=
18205][SQLGetData.c][224]
Entry:
Statement =3D 0x892=
5b10

Column Number =3D 2
Target Type =3D -2 SQL_C_BINARY =

Buffer Length =3D 4096
Target Value =3D 0=
x8928b38
StrLen Or Ind =3D 0xbfffe598
[ODBC][18205][SQ=
LGetData.c][470]

Exit:[SQL_SUCCESS_WITH_INFO]
Buffer =3D [BINARYDATA=
....]
Strlen Or Ind =3D 0xbfffe598 -> 6641
DIA=
G [01004] The buffer was too small for the GetData.

odbc-log--08.04.0200.log

--------------------------------- div>

[ODBC][18605][SQLGetData.c][224]
Entry:
Sta=
tement =3D 0x8933318
Column Number =3D 2
=
Target Type =3D -2 SQL_C_BINARY

Buffer Length =3D 4096
Target Value =3D 0x8938888 =

StrLen Or Ind =3D 0xbfffe598
[ODBC][18605][SQLGetData.c][4=
70]
Exit:[SQL_SUCCESS]
Buffer =3D [BINARYDATA...=
]

Strlen Or Ind =3D 0xbfffe598 -> 3321

Bes=
t regards,

Vladimir Kokovic, DP senior, Belgrade, Serbia

--e0cb4e7004cfcb70c804901093d6--