Thank you for your quick response.
I understand '\0' cannot be stored in VARCHAR/CHAR columns.
I just wonder whether JDBC driver should truncate String without notice or not. Throwing exception is understandable
butthe
behavior was changed in 8.1.
This may be a compatibility issue.
Thanks,
ebi
> -----Original Message-----
> From: pgsql-jdbc-owner@postgresql.org
> [mailto:pgsql-jdbc-owner@postgresql.org] On Behalf Of Larry Rosenman
> Sent: Wednesday, May 17, 2006 10:48 PM
> To: Marc Herbert; pgsql-jdbc@postgresql.org
> Subject: Re: [JDBC] how to handle data containing '\0'
>
>
> Marc Herbert wrote:
> > "EBIHARA, Yuichiro" <ebihara@iplocks.co.jp> writes:
> >
> >>
> >> I need to handle String data containing '\0' in my Java + JDBC
> >> program. Such data can happen at other systems and be sent to
> >> PostgreSQL. Here is a sample to simulate it in Java code.
> >
> > As far as I know, it is not possible to store such strings in a
> > postgreSQL database (whatever the client interface used).
> The reason
> > seems to be that postgreSQL is written in C, and most C
> functions use
> > \0 as a string terminator.
> >
> the bytea datatype handles such strings.
>
> LER
>
> --
> Larry Rosenman
> Database Support Engineer
>
> PERVASIVE SOFTWARE. INC.
> 12365B RIATA TRACE PKWY
> 3015
> AUSTIN TX 78727-6531
>
> Tel: 512.231.6173
> Fax: 512.231.6597
> Email: Larry.Rosenman@pervasive.com
> Web: www.pervasive.com
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match
>
>
>