Re: Empty bytea values on 9.2.1 - Mailing list pgsql-odbc

From Nils Gösche
Subject Re: Empty bytea values on 9.2.1
Date
Msg-id 001101cdb686$b80fd290$282f77b0$@de
Whole thread Raw
In response to Re: Empty bytea values on 9.2.1  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Empty bytea values on 9.2.1  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-odbc
Tom wrote:

> 9.0 and later default to showing bytea output in "hex" format.  I
> wonder whether you are using a version of the ODBC code that handles
> that.

I am using version 9.01.02.00 which is rather recent, I think.

> If not, you many need to set "bytea_output" to "escape".

Good idea: That fixes it!

Interestingly, longer bytea values seem to work fine even without
setting bytea_output to 'escape'! It's only the empty arrays that
seem to make problems.

Regards,
--
Nils Gösche
"Don't ask for whom the <CTRL-G> tolls."




pgsql-odbc by date:

Previous
From: Tom Lane
Date:
Subject: Re: Empty bytea values on 9.2.1
Next
From: Tom Lane
Date:
Subject: Re: Empty bytea values on 9.2.1