Re: Problems retrieving data from bytea field

You can take the pg72jdbc.jar, this works. (with postgres 7.3 and
bytea's).

Dirk




>-----Ursprüngliche Nachricht-----
>Von: pgsql-jdbc-owner@postgresql.org
>[mailto:pgsql-jdbc-owner@postgresql.org] Im Auftrag von Barry Lind
>Gesendet: Mittwoch, 9. April 2003 23:29
>An: Iran
>Cc: pgsql-jdbc@postgresql.org
>Betreff: Re: [JDBC] 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)
>>
>
>
>---------------------------(end of
>broadcast)---------------------------
>TIP 6: Have you searched our list archives?
>
>http://archives.postgresql.org
>
>