| From: | "Larry Rosenman" <lrosenman(at)pervasive(dot)com> |
|---|---|
| To: | "Marc Herbert" <Marc(dot)Herbert(at)continuent(dot)com>, <pgsql-jdbc(at)postgresql(dot)org> |
| Subject: | Re: how to handle data containing '\0' |
| Date: | 2006-05-17 13:48:21 |
| Message-ID: | F6616E0E81AC0841B1F9DD252F7C4B55041A74@ausmaildd.aus.pervasive.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | EBIHARA, Yuichiro | 2006-05-17 14:36:59 | Re: how to handle data containing '\0' |
| Previous Message | Marc Herbert | 2006-05-17 13:13:03 | Re: how to handle data containing '\0' |