=?utf-8?Q?Nils_G=C3=B6sche?= <cartan(at)cartan(dot)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