Re: bytea and character encoding when inserting escaped literals - Mailing list pgsql-general

From Raymond O'Donnell
Subject Re: bytea and character encoding when inserting escaped literals
Date
Msg-id 4821A0D3.9030305@iol.ie
Whole thread Raw
In response to bytea and character encoding when inserting escaped literals  (Lee Feigenbaum <lee@thefigtrees.net>)
List pgsql-general
On 05/05/2008 16:07, Lee Feigenbaum wrote:

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

As I understand it, the octets need to be entered as their octal
representation - have a look at table 8-7 at
http://www.postgresql.org/docs/8.3/static/datatype-binary.html.

HTH,

Ray.

------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------

pgsql-general by date:

Previous
From: Jan Christian Dittmer
Date:
Subject: Import German Decimal Numbers
Next
From: "A. Kretschmer"
Date:
Subject: Re: Import German Decimal Numbers