Skip site navigation (1) Skip section navigation (2)

Re: bytea encoding

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: Jesse Eichar <jeichar(at)refractions(dot)net>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: bytea encoding
Date: 2005-05-11 21:53:00
Message-ID: 42827EBC.5070707@opencloud.com (view raw or flat)
Thread:
Lists: 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

In response to

Responses

pgsql-jdbc by date

Next:From: Kris JurkaDate: 2005-05-11 22:04:08
Subject: Re: PostgreSQL, WebObjects and fetchSize
Previous:From: Oliver JowettDate: 2005-05-11 21:49:23
Subject: Re: PostgreSQL, WebObjects and fetchSize

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group