Re: how to handle data containing '\0'

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 but the
behavior was changed in 8.1.

This may be a compatibility issue.

Thanks,

ebi

> -----Original Message-----
> From: pgsql-jdbc-owner(at)postgresql(dot)org
> [mailto:pgsql-jdbc-owner(at)postgresql(dot)org] On Behalf Of Larry Rosenman
> Sent: Wednesday, May 17, 2006 10:48 PM
> To: Marc Herbert; pgsql-jdbc(at)postgresql(dot)org
> Subject: Re: [JDBC] how to handle data containing '\0'
>
>
> Marc Herbert wrote:
> > "EBIHARA, Yuichiro" <ebihara(at)iplocks(dot)co(dot)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(dot)Rosenman(at)pervasive(dot)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
>
>
>