From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
---|---|
To: | yang zhenyu <zhyuyang(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: PQexec(), what should I do for the "NULL in command" problem? |
Date: | 2007-11-13 07:21:54 |
Message-ID: | 20071113072154.GA6945@svana.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Tue, Nov 13, 2007 at 10:52:09AM +0800, yang zhenyu wrote:
> > > But there exist "\0" in some data filed, and I found PQexec() failed
> > > on such situation.
>
> Thanks for reply :-)
> But would you please give me more details or some references?
>
> > Two ways:
> > - out of line parameters
> How to? Is there any function for this? I mean the C interface.
PQexecParams.
> > - escape the nulls, like \0
> Do you mean this function?
> #unsigned char *PQescapeBytea(const unsigned char *from,
> # size_t from_length,
> # size_t *to_length);
>
> But after the "escape", the data is changed, and it cannot
> automatically change back when insert them into database.
> I have to "unescape" it when query. Is this necessary?
True. You should realise that the text data type does not handle
embedded nulls, that's why the bytea datatype exists. If you don't want
the full conversion, you'll need to handle your own escaping.
PostgreSQL is not going return you strings with embedded NULLs...
Have a nice day,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> Those who make peaceful revolution impossible will make violent revolution inevitable.
> -- John F Kennedy
From | Date | Subject | |
---|---|---|---|
Next Message | Decibel! | 2007-11-13 08:36:22 | Re: Using generate_series to create a unique ID in a query? |
Previous Message | Ow Mun Heng | 2007-11-13 06:37:24 | Re: Calculation for Max_FSM_pages : Any rules of thumb? |