Postgres Pro
Downloads
Home   >   mailing lists

Re: how to handle data containing '\0' - Mailing list pgsql-jdbc

From Marc Herbert
Subject Re: how to handle data containing '\0'
Date
Msg-id khjd5ecvlpc.fsf@meije.emic.fr
Whole thread Raw
In response to how to handle data containing '\0'  ("EBIHARA, Yuichiro" <ebihara@iplocks.co.jp>)
List pgsql-jdbc
Tree view 
"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
sentto 
> 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.

pgsql-jdbc by date:

Previous
From: "EBIHARA, Yuichiro"
Date:
Subject: how to handle data containing '\0'
Next
From: "Larry Rosenman"
Date:
Subject: Re: how to handle data containing '\0'