Re: bytea and character encoding when inserting escaped literals

by asche.public@[EMAIL PROTECTED] (Asche) May 5, 2008 at 05:21 PM

Hi Lee,

On 05.05.2008, at 17:07, Lee Feigenbaum wrote:
> INSERT INTO myTable VALUES (..., E'\x15\x1C\x2F\x00\x02...', ...) ;

try escaping the backslashes:

INSERT INTO myTable VALUES (..., E'\\x15\\x1C\\x2F\\x00\\x02...', ...) ;

Jan

-- 
Sent via pgsql-general mailing list (pgsql-general@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

8 Posts in Topic:

bytea and character encoding when inserting escaped literals

lee@[EMAIL PROTECTED] (L

2008-05-05 11:07:12

Re: bytea and character encoding when inserting escaped literals

asche.public@[EMAIL PROTE

2008-05-05 17:21:16

Re: bytea and character encoding when inserting escaped

lee@[EMAIL PROTECTED] (L

2008-05-05 11:30:29

Re: bytea and character encoding when inserting escaped

asche.public@[EMAIL PROTE