--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
<div>Hi,</div><div><br></div><div>In all versions up to version 9.1devel Po=
stgreSQL, ODBC driver '07 .03.0100 'has worked well with fields of =
type bytea.<br></div><div><br></div><div>In the version of PostgreSQL 9.1de=
vel, ODBC Driver '07 .03.0100 ' returns greater length than length =
of the field,</div>
<div>ODBC Driver '08 .04.0200' returns the correct length of the fi=
eld.<br></div><div><br></div><div>postgresql.conf<br></div><div>-----------=
---------</div><div>#bytea_output =3D 'hex' =A0 =A0 =A0 =A0 =A0 =A0=
# hex, escape</div>
<div>standard_conforming_strings =3D off</div><div><br></div><div>odbc-log-=
07.03.0100.log</div><div>--------------------------------</div><div>[ODBC][=
18205][SQLGetData.c][224]<br> Entry: <br> Statement =3D 0x892=
5b10 <br>
Column Number =3D 2 <br> Target Type =3D -2 SQL_C_BINARY =
<br> Buffer Length =3D 4096 <br> Target Value =3D 0=
x8928b38 <br> StrLen Or Ind =3D 0xbfffe598<br>[ODBC][18205][SQ=
LGetData.c][470]<br>
Exit:[SQL_SUCCESS_WITH_INFO] <br> Buffer =3D [BINARYDATA=
....] <br> Strlen Or Ind =3D 0xbfffe598 -> 6641<br> DIA=
G [01004] The buffer was too small for the GetData.<br></div><div><br></div=
>
<div>odbc-log--08.04.0200.log</div><div>---------------------------------</=
div><div>[ODBC][18605][SQLGetData.c][224]<br> Entry: <br> Sta=
tement =3D 0x8933318 <br> Column Number =3D 2 <br> =
Target Type =3D -2 SQL_C_BINARY <br>
Buffer Length =3D 4096 <br> Target Value =3D 0x8938888 =
<br> StrLen Or Ind =3D 0xbfffe598<br>[ODBC][18605][SQLGetData.c][4=
70]<br> Exit:[SQL_SUCCESS] <br> Buffer =3D [BINARYDATA...=
] <br>
Strlen Or Ind =3D 0xbfffe598 -> 3321<br></div><div><br></div><div>Bes=
t regards,</div><div>Vladimir Kokovic, DP senior, Belgrade, Serbia</div><di=
v><br></div>
--e0cb4e7004cfcb70c804901093d6--
