| From: | pgsql-bugs(at)postgresql(dot)org |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Bug #767: Bug when inserting in "bytea" column type |
| Date: | 2002-09-14 20:41:36 |
| Message-ID: | 20020914204136.F2EB8475E26@postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
Roman A.Grigorovich (atz(at)atz(dot)msk(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2002-09-14 20:49:10 | Re: Bug #767: Bug when inserting in "bytea" column type |
| Previous Message | Tom Lane | 2002-09-14 15:46:11 | Re: Bug #766: version difference creates problem |