| From: | Nils Gösche <cartan(at)cartan(dot)de> | 
|---|---|
| To: | <pgsql-odbc(at)postgresql(dot)org> | 
| Subject: | Empty bytea values on 9.2.1 | 
| Date: | 2012-10-29 17:58:14 | 
| Message-ID: | 006a01cdb5fe$f8400c00$e8c02400$@de | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-odbc | 
Hi!
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. The tables
look the same on the new installation: Zero length of the bytea values in some
columns. However, if I try to retrieve such rows with the exact same program as
above, with the same ODBC driver, same connection string except the host name,
suddenly I get a byte[] object of length 1! And the one byte in that array
appears to be random!
At first, I thought it might be a Postgres bug. I wrote a simple program that
uses Npgsql to retrieve those rows, however, the behavior wasn't reproducible
anymore that way. It occurs only if I use ODBC. So, I suspect there is something
in the ODBC driver causing this.
Can anybody else confirm this?
Regards,
-- 
Nils Gösche
"Don't ask for whom the <CTRL-G> tolls."
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nils Gösche | 2012-10-29 18:01:42 | Re: PostgreSQL driver not visible in windows control panel | 
| Previous Message | Fred Parkinson | 2012-10-29 17:50:49 | PostgreSQL driver not visible in windows control panel |