Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group