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

From: Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>
To: vicen(at)pv2c(dot)sk
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Bug #653: Unable to insert binary data into BYTEA
Date: 2002-05-02 09:48:16
Message-ID: 20020502184816N.t-ishii@sra.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

> 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 has been fixed in that way in current). Or you
could cast them as bytea.
--
Tatsuo Ishii

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tatsuo Ishii 2002-05-02 10:01:40 Re: Bug #654: lower and to_ascii don't work with UTF8
Previous Message pgsql-bugs 2002-05-02 09:43:04 Bug #654: lower and to_ascii don't work with UTF8