Re: Record

[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(dot)com(at)interlock(dot)lexmark(dot)com> on
10/24/2001 06:41:11 PM

To: "Wesley_Sheldahl/Lex/Lexmark.LEXMARK"@sweeper.lex.lexmark.com
cc: julio%bntsoft(dot)com(dot)br(at)interlock(dot)lexmark(dot)com,
pgsql-general%postgresql(dot)org(at)interlock(dot)lexmark(dot)com,
alvherre%atentus(dot)com(at)interlock(dot)lexmark(dot)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(at)lexmark(dot)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.
>