On Fri, Aug 21, 2009 at 06:54:51PM +0300, Andrus Moor wrote: > create temp table test ( test bytea ); > insert into test values(E'\274') > > Causes error Yup, you want another backslash in there, something like: insert into test values(E'\\274'); The first backslash is expanded out during parsing the SQL into a literal and the second during parsing of the literal into a bytea value. You've got the following transformation going on: SQL -> Literal -> Bytea value The character values at each stage go like this: SQL : 5c 5c 32 37 34 Literal : 5c 32 37 34 (because the '\\' has been unescaped to a '\') Bytea : bc > In 8.2 this script runs OK. Maybe it's in SQL_ASCII encoding? NUL characters wouldn't work in your 8.2 database if that's the case. -- Sam http://samason.me.uk/ -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
