From: | "Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
---|---|
To: | "Manish Jain *EXTERN*" <manish(dot)jain(at)globallogic(dot)com>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Not able to insert binary Data having NULL |
Date: | 2007-10-11 08:34:44 |
Message-ID: | D960CB61B694CF459DCFB4B0128514C25689CC@exadv11.host.magwien.gv.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Manish Jain wrote:
> I have bytea column in one table and using C language, I am
> trying to insert a binary data (having NULLs)
>
> into bytea column, but it just inserts/updates till NULL reached.
>
> Please let know whether I am missing something.
I guess that when you say NULL you don't mean SQL NULL, but
the byte E'\\000', right? The rest of my E-Mail is based on
that assumption.
When calling PQexecParams to store a bytea, either set
paramFormats[i] to 0 (text) and use escape sequences as above,
or set paramFormats[i] to 1 (binary) and dont't forget to set
paramLengths[i] to the length of the binary data.
> Any other approach - may I use some data type instead of
> bytea so that any binary data can go there?
Large Objects.
But there's nothing wrong with bytea.
Yours,
Laurenz Albe
From | Date | Subject | |
---|---|---|---|
Next Message | Carlos H. Reimer | 2007-10-11 11:33:12 | RES: 8.2.4 selects make applications wait indefinitely |
Previous Message | Richard Huxton | 2007-10-11 07:47:24 | Re: Not able to insert binary Data having NULL |