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

From Dave Smith
Subject Re: JDBC Prepared Statement Bug
Date
Msg-id 3C90CC01.20701@candata.com
Whole thread Raw
In response to JDBC Prepared Statement Bug  (Dave <dave@candata.com>)
List pgsql-general
Well it is actually coded as '\u0000' which is valid value for a
character type. The 'C' backend takes this as '\0' and and end of line
terminator.

Doug McNaught wrote:
> 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



pgsql-general by date:

Previous
From: "UAP2"
Date:
Subject: plpgsql function docs
Next
From: "Joey Mingrone"
Date:
Subject: problem authenticating with encrypted passwords in pg_shadow