Re: [INTERFACES] DBD::Pg and binary data

[Crist�v�o Dalla Costa]

Rudy Lippan wrote:

On Wed, 23 Oct 2002, David Wheeler wrote:


>Okay, the problem is that DBD::Pg's execute() method doesn't call
>quote() for the parameters passed to it. So quote() is never called for
>your code. The good news is that you don't have to base64 encode your
>binary data. Instead, call the quote() method yourself:
>
>while (my $rd = read $fh, $data2, 65536) {
>	$data .= $dbh->quote($data2);
>	$datasize += $rd;
>}
>

Try binding as SQL_BINARY and let me know if that works.

Both means (using quote() or bind_param()) do give the expected results. Yet, I don't see a reason to do the quoting differently between text and binary data.

(getting them out, is a complately different problem).

Well, after I got the data in it came back out without problem, using the vanilla commands.

Thanks to all.

Crist�v�o