Search Postgresql Archives

Bytea question with \208

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

               http://archives.postgresql.org/

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux