From: | "Woody Woodring" <george(dot)woodring(at)iglass(dot)net> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Bytea question with \208 |
Date: | 2007-08-09 16:14:46 |
Message-ID: | 006701c7daa0$66fa4a10$80b1a8c0@istructure.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Could someone explain why \208 is not a valid syntax for bytea?
I am getting the following:
test=> select E'\\207'::bytea;
bytea
-------
\207
(1 row)
test=> select E'\\208'::bytea;
ERROR: invalid input syntax for type bytea
test=> select E'\\209'::bytea;
ERROR: invalid input syntax for type bytea
test=> select E'\\210'::bytea;
bytea
-------
\210
(1 row)
This all started when our version(older) of bugzilla trying to open a new
bug with a word attachment via email:
Aug 9 11:43:15 brain01 postgres[8631]: [5-1] ERROR: invalid byte sequence
for encoding "UTF8": 0xd0cf
The first two bytes of the word document are 0xd0 0xcf and I am assuming
they are putting the two together since 0xd0 is invalid
0xd0 == \208
Thanks,
Woody
----------------------------------------
iGLASS Networks
211-A S. Salem St
Apex NC 27502
(919) 387-3550 x813
www.iglass.net
From | Date | Subject | |
---|---|---|---|
Next Message | Erik Jones | 2007-08-09 16:29:10 | Re: Reordering columns, will this ever be simple? |
Previous Message | Leif B. Kristensen | 2007-08-09 16:14:43 | Re: Modified FIFO queue and insert rule |