Re: bytea and character encoding when inserting escaped literals

From: Raymond O'Donnell <rod(at)iol(dot)ie>
To: Lee Feigenbaum <lee(at)thefigtrees(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: bytea and character encoding when inserting escaped literals
Date: 2008-05-07 12:30:11
Message-ID: 4821A0D3.9030305@iol.ie
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)iol(dot)ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------

In response to

Browse pgsql-general by date

  From Date Subject
Next Message A. Kretschmer 2008-05-07 12:37:43 Re: Import German Decimal Numbers
Previous Message Jan Christian Dittmer 2008-05-07 12:25:13 Import German Decimal Numbers