Re: [GENERAL] 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 par

Re: [GENERAL] Error inserting data to bytea column in 8.4

2009/8/21 Andrus Moor : > In 8.4, script > > create temp table test ( test bytea ); > insert into test values(E'\274') Try E'\\274' -- greg http://mit.edu/~gsstark/resume.pdf -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www

[GENERAL] Error inserting data to bytea column in 8.4

In 8.4, script create temp table test ( test bytea ); insert into test values(E'\274') Causes error ERROR: invalid byte sequence for encoding "UTF8": 0xbc HINT: This error can also happen if the byte sequence does not match the encoding expected by the server, which is controlled by "client_