Postgres Pro
Downloads
Home   >   mailing lists

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

From Larry Rosenman
Subject Re: how to handle data containing '\0'
Date
Msg-id F6616E0E81AC0841B1F9DD252F7C4B55041A74@ausmaildd.aus.pervasive.com
Whole thread Raw
In response to how to handle data containing '\0'  ("EBIHARA, Yuichiro" <ebihara@iplocks.co.jp>)
Responses Re: how to handle data containing '\0'  ("EBIHARA, Yuichiro" <ebihara@iplocks.co.jp>)
List pgsql-jdbc
Tree view 
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

pgsql-jdbc by date:

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