Re: updateBlob()-example? - Mailing list pgsql-jdbc

From Kris Jurka
Subject Re: updateBlob()-example?
Date
Msg-id Pine.LNX.4.33.0402120448480.5286-100000@leary.csoft.net
Whole thread Raw
In response to Re: updateBlob()-example?  (Guido Fiala <guido.fiala@dka-gmbh.de>)
List pgsql-jdbc

On Thu, 12 Feb 2004, Guido Fiala wrote:

> Am Donnerstag, 12. Februar 2004 10:05 schrieb Kris Jurka:
> > pass compatible=7.1 as a URL parameter
>
> How do i specify that paramter in the URL?
>

Something like:

jdbc:postgresql://localhost:5432/mydatabase?compatible=7.1


> > Could you be more clear on what you want to do and where it is failing?
>
> I tried using rs.updateBytes() and using bytea datatype and writing seems to
> work now.
> But if the data are read back using getBytes() the RTF-Editorkit mourns about
> "to many closed brackets", but that might not be a problem of JDBC, still
> tracking it down.
>

There is a bug in the server where it tries to do character set conversion
on bytea data.  If your database is not in UNICODE encoding this may be
the issue.  Using unicode or large objects will avoid this problem.

Kris Jurka


pgsql-jdbc by date:

Previous
From: Guido Fiala
Date:
Subject: Re: updateBlob()-example?
Next
From: Gary Quinn
Date:
Subject: unsubscribe