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

From: pgsql-bugs(at)postgresql(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: Bug #653: Unable to insert binary data into BYTEA column in UTF8 DB
Date: 2002-05-02 09:36:00
Message-ID: 20020502093600.1E48F476005@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Peter Vicen (vicen(at)pv2c(dot)sk) 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 the parser rejects insert queries with binary data because they're not UTF8 encoded (escaping doesn't help ;-).

Sample Code

No file was uploaded with this report

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message pgsql-bugs 2002-05-02 09:43:04 Bug #654: lower and to_ascii don't work with UTF8
Previous Message R Ravishankar 2002-05-02 04:51:28 Re: Bug #651: Time difference of 30 in while reading in timestamp