Postgres Pro
Downloads
Home   >   mailing lists

Re: JDBC Prepared Statement Bug - Mailing list pgsql-general

From Doug McNaught
Subject Re: JDBC Prepared Statement Bug
Date
Msg-id m3n0xbqhdy.fsf@varsoon.denali.to
Whole thread Raw
In response to JDBC Prepared Statement Bug  (Dave <dave@candata.com>)
List pgsql-general
Tree view 
Dave <dave@candata.com> writes:

> I am trying to use a Prepared Statement that has a character type. The
> value I am trying to use is  '\0' and it is getting set with the
> setObject method.

'\0' is not a legal value for character types.  You'll need to use the
BYTEA type instead and quote it properly.

-Doug
--
Doug McNaught       Wireboard Industries      http://www.wireboard.com/

      Custom software development, systems and network consulting.
      Java PostgreSQL Enhydra Python Zope Perl Apache Linux BSD...

pgsql-general by date:

Previous
From: Doug McNaught
Date:
Subject: Re: order by a XML column
Next
From: Stephan Szabo
Date:
Subject: Re: Select not using primary key index