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.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.
>