Bug #40913 [Com]: PDO::PARAM_LOB does not bind to a stream for fetching a BLOB

Edit report at https://bugs.php.net/bug.php?id=40913&edit=1 ID: 40913 Comment by: david dot palella at gmail dot com Reported by: dennis at inmarket dot lviv dot ua Summary: PDO::PARAM_LOB does not bind to a stream for fetching a BLOB Status: Closed Type: Bug Package: PDO related Operating System: Win XP PHP Version: 5.2.6 Assigned To: mysql Block user comment: N Private report: N New Comment: The problem is still present with PHP v. 5.3.10 and Ubuntu 12.10 Previous Comments: ------------------------------------------------------------------------ [2011-10-20 09:48:17] oridan82 at gmail dot com PHP 5.3.5 PARAM_LOB is returning a string instead of a stream. Code: ----- $stmt = $conn->prepare($qry); $stmt->bindValue(1, $_GET['id']); $stmt->bindValue(2, $_GET['aid']); $stmt->execute(); $stmt->bindColumn(4, $mimeType, PDO::PARAM_STR, 256); $stmt->bindColumn(6, $lob, PDO::PARAM_LOB); $stmt->fetch(PDO::FETCH_BOUND); echo gettype($lob); Expected Result: ---------------- resource Actual Result: -------------- string ------------------------------------------------------------------------ [2011-01-04 13:21:09] uw@php.net See last comment, works with 5.3.4 ------------------------------------------------------------------------ [2010-12-27 01:02:32] php at paloch dot net Seems to be fixed in 5.3.4 final. I was struggling with this issue (and PHP 5.2.16) all evening before finding this post. I tried installing PHP 5.3.4 and voila, problem solved. ------------------------------------------------------------------------ [2010-11-22 10:43:16] uw@php.net 5.2 only gets security fixes, if at all. Can this be reproduced with 5.3.4-RC, using libmysql (recent one!), using mysqlnd? ------------------------------------------------------------------------ [2010-10-05 18:10:13] samuel at ingessons dot se And another reason why I need a stream and not a string is that a string would consume all the memory for a large object. ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at https://bugs.php.net/bug.php?id=40913 -- Edit this bug report at https://bugs.php.net/bug.php?id=40913&edit=1