On Mon, Jan 21, 2002 at 08:36:38AM +0100, Wiedmann, Jochen wrote:
>
> > In the first case SQL::Parser has to know how to parse a statement SQL
> > containing a blob and in the second case it can just allow
> > SQL::Statement to insert the blob without having to parse it
> > within the
> > context of the SQL statement.
>
> Well, of course it is only valid to use
>
> $dbh->do("INSERT INTO foo VALUES (" . $dbh->quote($blob) . ")");
>
> IMO, if this works, it should continue to work, because it
> seems quite legal. Without quote, of course, nothing's got
> to work.
I should point out here that there's nothing wrong with
$dbh->quote("one\ntwo\0three")
returning something like
concat('one', char(12), 'two', char(0), 'three')
Not pretty, but valid for the intended purpose of quote.
Tim.
