RES: Problems retrieving data from bytea field

Thanks for the information.

Do you remember exactly the url for the bug message? If don't, no need
to reply.

Thanx anyway.

iran

> -----Mensagem original-----
> De: pgsql-jdbc-owner(at)postgresql(dot)org
> [mailto:pgsql-jdbc-owner(at)postgresql(dot)org] Em nome de Barry Lind
> Enviada em: quarta-feira, 9 de abril de 2003 18:29
> Para: Iran
> Cc: pgsql-jdbc(at)postgresql(dot)org
> Assunto: 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(at)postgresql(dot)org)
> >
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
http://archives.postgresql.org