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