Bug #767: Bug when inserting in "bytea" column type

Started by PostgreSQL Bugs Listover 23 years ago2 messagesbugs
Jump to latest
#1PostgreSQL Bugs List
pgsql-bugs@postgresql.org

Roman A.Grigorovich (atz@atz.msk.ru) reports a bug with a severity of 1
The lower the number the more severe it is.

Short Description
Bug when inserting in "bytea" column type

Long Description
PosgreSQL version 7.2.2
./configure --prefix=/usr/local/pgsql --enable-multibyte=WIN --cache-file=/dev/null

In "psql" command line tool:
CREATE TABLE IMAGES (ID SERIAL,NAME VARCHAR(32), DATA BYTEA);
and then i type.

INSERT INTO IMAGES (NAME,DATA) VALUES ('image1','\377\000\556\211\000');

after this i do next:
SELECT * FROM IMAGES;
and result of this query was:
ID | NAME | DATA
1 image1 \377

all data after '\000' have been missed. Is this a bug?

From PHP 4.0.6-client this work the same.

Sample Code

No file was uploaded with this report

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: PostgreSQL Bugs List (#1)
Re: Bug #767: Bug when inserting in "bytea" column type

pgsql-bugs@postgresql.org writes:

INSERT INTO IMAGES (NAME,DATA) VALUES ('image1','\377\000\556\211\000');

You need to double all those backslashes.

regards, tom lane