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

=?utf-8?Q?Nils_G=C3=B6sche?= <cartan@cartan.de> writes:
> On an 8.4 installation, I have a table with a bytea column. In some rows, the
> value of this column has length 0. When I query that table with a normal SELECT,
> using the ODBC driver from C#, I get a byte[] object of length 0 on those rows.

> So far so good.

> Now, I dumped the database and restored it on a 9.2.1 installation.

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.
If not, you many need to set "bytea_output" to "escape".

            regards, tom lane