SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-16-2008, 12:13 AM
| ||||
| ||||
 Problem with JDBC and Large Objects 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...4/msg00216.php http://mail-archive.objectweb.org/do.../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. 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.) Any suggestions? Is this a bug? (If it is a bug, it seems hard to believe that nobody has run across this.) Thanks in advance! Randall      |
|
04-16-2008, 12:13 AM
| ||||
| ||||
| 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...4/msg00216.php > * http://mail-archive.objectweb.org/do.../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 ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq |
Linear Mode
