Re: bytea encoding - Mailing list pgsql-jdbc

From Oliver Jowett
Subject Re: bytea encoding
Date
Msg-id 42827EBC.5070707@opencloud.com
Whole thread Raw
In response to bytea encoding  (Jesse Eichar <jeichar@refractions.net>)
Responses Re: bytea encoding
List pgsql-jdbc
Jesse Eichar wrote:

> 1. Is the byte stream (or byte array) converted to bytea on the database
> side or on client before sending?  (My client is using the
> postgresql-74.213.jar).

You give the driver a byte[] (setBytes) or InputStream
(setBinaryStream); it does the rest. Old drivers such as build 213 will,
IIRC, convert this to a text representation internally before sending to
the backend; newer drivers will send the data directly without
conversion. But this is all transparent to the client.

-O

pgsql-jdbc by date:

Previous
From: Oliver Jowett
Date:
Subject: Re: PostgreSQL, WebObjects and fetchSize
Next
From: Kris Jurka
Date:
Subject: Re: PostgreSQL, WebObjects and fetchSize