Re: Error inserting data to bytea column in 8.4

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/