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 ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])