Re: UTF-8 context of BYTEA datatype?? - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: UTF-8 context of BYTEA datatype??
Date
Msg-id 20060531102921.GE23169@svana.org
Whole thread Raw
In response to Re: UTF-8 context of BYTEA datatype??  ("Daniel Verite" <daniel@manitou-mail.org>)
List pgsql-general
On Wed, May 31, 2006 at 11:31:28AM +0200, Daniel Verite wrote:
>     Martijn van Oosterhout wrote:
>
> > However, there is a solution: send the paramters seperate from the
> > query. In fact, postgres has been able to do that for a while now but
> > not all interfaces have been made to use it. My guess is that those
> > other databases you've used were already doing this so didn't see the
> > issue. I don't know if DBD:Pg does this though, maybe it needs to be
> > triggered somehow.
>
> Actually, this is the case already. When a parameter is explicitly
> typed as bytea, then libpq's PQexecPrepared is used and the binary
> contents are passed outside of the query.

Why isn't PQexecPrepared always used? And why does typing it SQL_BINARY
not do the same?

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

Attachment

pgsql-general by date:

Previous
From: Arnaud Lesauvage
Date:
Subject: Re: Best high availability solution ?
Next
From: Tino Wildenhain
Date:
Subject: Re: Best high availability solution ?