Re: PQescapeBytea is not multibyte aware

Tom Lane wrote:
>>INSERT INTO t1(bytea_col) VALUES('characters produced by
>>PQescapebytea'::bytea);
> 
> 
> Probably that would cause the error to disappear, but it's hardly a
> desirable answer.
> 
> I wonder whether this says that TEXT is not a good implementation of
> type UNKNOWN.  That choice was made on the assumption that TEXT would
> faithfully preserve the contents of a C string ... but it seems that in
> the multibyte world it ain't so.  It would not be a huge amount of work
> to write a couple more I/O routines and give UNKNOWN its own I/O
> behavior.


I could take a look at this. Any guidance other than "faithfully 
preserving the contents of a C string"?

> 
> OTOH, I was surprised to read your message because I had assumed the
> damage was being done much further upstream, viz during collection of
> the query string by pq_getstr().  Do we need to think twice about that
> processing, as well?

I'll take a look at this as well.

Joe