#40913 [Ctl->Asn]: PDO::PARAM_LOB does not bind to a stream for fetching a BLOB

ID: 40913 Updated by: tony2001@php.net Reported By: dennis at inmarket dot lviv dot ua -Status: Critical +Status: Assigned Bug Type: PDO related Operating System: Win XP PHP Version: 5.2.1 Assigned To: wez Previous Comments: ------------------------------------------------------------------------ [2007-03-25 12:29:07] dennis at inmarket dot lviv dot ua Description: ------------ PDOStatement::bindColumn($idx, $var, PDO::PARAM_LOB) for SELECT query makes $var a string with the BLOB Data rather than a stream, for both MySQL and SQLite. Reproduce code: --------------- $id = (int)$_REQUEST['book']; $stmt = $conn->prepare("SELECT coverMime, coverImage FROM books WHERE id=$id"); $stmt->execute(); $stmt->bindColumn(1, $mime); $stmt->bindColumn(2, $image, PDO::PARAM_LOB); $stmt->fetch(PDO::FETCH_BOUND); var_dump($image); Expected result: ---------------- Resource #1 Actual result: -------------- String(792) {GIF89a...} ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=40913&edit=1