Re: Problems retrieving data from bytea field

Iran,

This is a bug in the database server in 7.3.  The server is doing
character set translation on the binary data being returned to the jdbc
client.  This bug was reported a couple of months ago on the
pgsql-hackers mail list.  I don't know if it has been fixed yet.

thanks,
--Barry


Iran wrote:
> Hi. I'm havnig a problem when try to retrieve binary data from a bytea
> field where I'm storing na image (jpg).
>
> First of all, my setup is, RedHat 8.0, PostgreSQL 7.3.2 and I'm trying
> to access this data using the latest JDBC stable driver released (I
> think) which is the pg73jdbc2.jar (I tried with pg73jdbc3.jar too).
>
> The store process occurs nicely, but when I retrieve this data from
> database, it comes corrupted and I invariably got more bytes than I
> stored.
>
> What am I missing here?
>
> Thanx in advance.
>
> iran
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>