Re: Problem with JDBC and Large Objects

Randall Hauch wrote:
> I'm using the latest JDBC driver (8.1-407) with PostgreSQL 8.1.3 (on 
> Windows) and PostgreSQL 8.1.4 (on Debian).  I've searched the archives, 
> and found several applicable thread that were never responded to or 
> apparently resolved:
> 
>     * http://archives.postgresql.org/pgsql-bugs/2001-04/msg00216.php
>     * http://mail-archive.objectweb.org/dods/2001-11/msg00007.html
> 
> I'm using JDBC to store (binary) files in a database, and have tried 
> storing the content in a BYTEA column and using the Large Object API and 
> storing a OID column in my table. 

So.. which one did you see the problem with, LOB or bytea?

> I am able to upload various files 
> into the database, but when I download them the 0xFF characters in the 
> uploaded files have all been stripped.  I've looked for a configuration 
> setting, but don't see anything of use.  (The database or client 
> character encodings should not apply to binary data.)

Weird. Do you have a testcase I can try?

-O