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

Re: blobs in a client/server environment

From: Pete Jewell <pete(at)example(dot)compulink(dot)co(dot)uk>
To: Matt Fair <matt(at)netasol(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: blobs in a client/server environment
Date: 2001-09-27 10:28:07
Message-ID: m31yktyll4.fsf@example.compulink.co.uk (view raw or flat)
Thread:
Lists: pgsql-jdbc
Matt Fair <matt(at)netasol(dot)com> writes:

> Hello,
> I have been playing around with storing images with setBinaryStream
> and getBinaryStream for a couple of days now, but I am continually
> running into a problem.  I don't know if I am getting the data in the
> right format or not, but I am not able to get my image from the
> database.
> I have a client/server environment and when I get the image back from
> the database that is done on the server.  So I do not want to write
> the InputStream as a file, instead as an array of bytes which are sent
> back to the client.
> I recive no errors when putting the image into the database and
> getting the  image out of the database, where I get my error is when I
> try to generate the image from the array of bytes.

Did you create the database with the -E UNICODE option?  If not, I
think you might find that the data is being stored as 7 bit ascii.
Caught me out too. :-)

HTH

-- 
Pete Jewell
Example Systems Ltd.
--------------------
The views expressed in this email may not be those
of Example Systems Ltd unless explicitly stated.

In response to

Responses

pgsql-jdbc by date

Next:From: Nick FankhauserDate: 2001-09-27 13:26:04
Subject: Re: Re. conection error
Previous:From: Russ McBrideDate: 2001-09-26 22:29:10
Subject: Re. conection error

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