Beefy Boxes and Bandwidth Generously Provided by pair Networks
Clear questions and runnable code
get the best and fastest answer
 
PerlMonks  

Re:^2 postgresql: store binary data?

by ph0enix (Friar)
on Dec 02, 2002 at 14:40 UTC ( [id://216931]=note: print w/replies, xml ) Need Help??


in reply to Re: postgresql: store binary data?
in thread postgresql: store binary data?

Now I'm found following note in the DBD::Pg module documentation.

  NOTE: The undocumented (and invalid) support for the
  "SQL_BINARY" data type is officially deprecated. Use
  "PG_BYTEA" with "bind_param()" instead:

  $rv = $sth->bind_param($param_num, $bind_value,
                         { pg_type => DBD::Pg::PG_BYTEA });

[download]

Code seems to work OK after modification

$sth->bind_param(2, nfreeze($test), { pg_type => DBD::Pg::PG_BYTEA });

Thanks

In Section Seekers of Perl Wisdom

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?

www.com | www.net | www.org
Node Status?
node history
Node Type: note [id://216931]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? • Last hour • Other CB clients
Other Users?
Others about the Monastery: (4)
As of 2024-04-24 04:32 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found