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/
