[Checking memory... can't remember ... checking code...]
Looks like I'm using DBI's bind_param instead, after the prepare and before the
execute statement. TMTOWTDI. :-)
$sth->bind_param(1, $my_binary_data, SQL_BINARY);
--Wes
"Aasmund Midttun Godal" <postgresql%envisity.com@interlock.lexmark.com> on
10/24/2001 06:41:11 PM
To: "Wesley_Sheldahl/Lex/Lexmark.LEXMARK"@sweeper.lex.lexmark.com
cc: julio%bntsoft.com.br@interlock.lexmark.com,
pgsql-general%postgresql.org@interlock.lexmark.com,
alvherre%atentus.com@interlock.lexmark.com (bcc: Wesley
Sheldahl/Lex/Lexmark)
Subject: Re: [GENERAL] Record
It handles the unescaping, but you have to escape to update/insert, I use:
s/([^\w])/sprintf("\\%03o", ord($1))/eg;
On Wed, 24 Oct 2001 11:42:31 -0400, wsheldah@lexmark.com wrote:
>
>
> If you're using Perl and the DBD::Pg driver, then you can use bytea without
> worrying about escaping anything, since the driver takes care of it.
>
