Re: [BUGS] Bug #653: Unable to insert binary data into BYTEA

2002-06-01 Thread Bruce Momjian
Tatsuo Ishii wrote: > > After creating an UTF8 database ("createdb --encoding "UTF8" ...) containing BYTEA >columns the parser rejects insert queries with 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 b

Re: [BUGS] Bug #653: Unable to insert binary data into BYTEA column

2002-06-01 Thread Bruce Momjian
This seems unusual. Would you send us a sample of a string that is rejected? --- [EMAIL PROTECTED] wrote: > Peter Vicen ([EMAIL PROTECTED]) reports a bug with a severity of 2 > The lower the number the more severe it is.

Re: [BUGS] Bug #653: Unable to insert binary data into BYTEA

2002-05-02 Thread Tatsuo Ishii
> After creating an UTF8 database ("createdb --encoding "UTF8" ...) containing BYTEA >columns the parser rejects insert queries with 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

[BUGS] Bug #653: Unable to insert binary data into BYTEA column in UTF8 DB

2002-05-02 Thread pgsql-bugs
Peter Vicen ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Unable to insert binary data into BYTEA column in UTF8 DB Long Description After creating an UTF8 database ("createdb --encoding "UTF8" ...) containing BYTEA columns