Bytea question with \208

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

Responses

Browse pgsql-general by date

  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