Bytea question with \208
От | Woody Woodring |
---|---|
Тема | Bytea question with \208 |
Дата | |
Msg-id | 006701c7daa0$66fa4a10$80b1a8c0@istructure.com обсуждение исходный текст |
Ответы |
Re: Bytea question with \208
|
Список | 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
В списке pgsql-general по дате отправления: