Re: Bug #653: Unable to insert binary data into BYTEA - Mailing list pgsql-bugs

From Tatsuo Ishii
Subject Re: Bug #653: Unable to insert binary data into BYTEA
Date
Msg-id 20020502184816N.t-ishii@sra.co.jp
Whole thread Raw
In response to Bug #653: Unable to insert binary data into BYTEA column in UTF8 DB  (pgsql-bugs@postgresql.org)
Responses Re: Bug #653: Unable to insert binary data into BYTEA
List pgsql-bugs
> After creating an UTF8 database ("createdb --encoding "UTF8" ...) containing BYTEA columns the parser rejects insert
querieswith binary data because they're not UTF8 encoded (escaping doesn't help ;-). 

I don't kno how exactly escaped them, but you need to escape bytes >
0x7f (PQescapebytea has been fixed in that way in current). Or you
could cast them as bytea.
--
Tatsuo Ishii

pgsql-bugs by date:

Previous
From: pgsql-bugs@postgresql.org
Date:
Subject: Bug #654: lower and to_ascii don't work with UTF8
Next
From: Tatsuo Ishii
Date:
Subject: Re: Bug #654: lower and to_ascii don't work with UTF8