From: Hugh Mandeville <hughmandeville@hotmail.com>
To: pgsql-sql@postgresql.org
Subject: Re: Re: binary data
Date: Thu, 21 Jun 2001 22:43:30 -0400
Message-ID: <9gubbo$s6b$1@news.tht.net> (raw)
References: <Pine.BSO.4.10.10106201342060.20262-100000@spider.pilosoft.com>
<9gtovc$mnr$1@news.tht.net>
this works
"Alex Pilosov" <alex@pilosoft.com> wrote in message
>> what is the correct way to escape 0? \000 doesn't work for me.
>The correct way is \\\\000 (yes really).
>
>If you are using DBD::Pg after 0.98, it will happen for you automatically
>if you bind the variable as SQL_BINARY.
>> i also tried doing an insert and using quote() with perl (DBD::Pg v1.0)
>You must use $dbh->quote($bindata,DBI::SQL_BINARY) (and DBD::Pg after 1.0)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: hughmandeville@hotmail.com
Subject: Re: Re: binary data
In-Reply-To: <9gubbo$s6b$1@news.tht.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox