Re: blobs in a client/server environment

Matt Fair <matt@netasol.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.