From: | Oliver Jowett <oliver(at)opencloud(dot)com> |
---|---|
To: | Randall Hauch <rhauch(at)revelytix(dot)com> |
Cc: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: Problem with JDBC and Large Objects |
Date: | 2006-08-10 07:17:50 |
Message-ID: | 44DADD9E.9090108@opencloud.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
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
From | Date | Subject | |
---|---|---|---|
Next Message | James Im | 2006-08-10 10:45:00 | Re: SQL query never ends |
Previous Message | Oliver Jowett | 2006-08-10 07:15:43 | Re: SQL query never ends |