$sth = $dbh->prepare($sql);
$sth->bind_col(1, \$lob);
$sth->execute();