Thread: Not able to insert binary Data having NULL

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.

Probably, but you'll need to explain how you're doing it at the moment.

How are you escaping your binary data?

--
   Richard Huxton
   Archonet Ltd

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