Bug #59375 [ReO->Dup]: BLOB inserts broken

Edit report at https://bugs.php.net/bug.php?id=59375&edit=1 ID: 59375 Updated by: adambaratz@php.net Reported by: kraven at kraven dot org Summary: BLOB inserts broken -Status: Re-Opened +Status: Duplicate Type: Bug Package: PDO DBlib Operating System: Linux or Windows PHP Version: 5.2.13 Block user comment: N Private report: N New Comment: My sense is that this lines up with the known issue with quoting binary values (67495). Regular string quoting should work fine. If something's wrong there, please post a more specific bug with the data involved so I can try to reproduce. Previous Comments: ------------------------------------------------------------------------ [2017-04-01 21:22:52] tpunt@php.net It's no longer apart a PECL extension... ------------------------------------------------------------------------ [2017-04-01 21:20:45] tpunt@php.net Due to this extension not seeing any activity since 2005, this issue will not be fixed. We are therefore closing this now. ------------------------------------------------------------------------ [2010-08-19 08:34:52] kraven at kraven dot org Description: ------------ BLOB inserts are broken. A syntax error will get thrown because of improper encoding of the binary stream. Reproduce code: --------------- COVER_IMAGE = VARBINARY(max) EXCERPT = VARCHAR(max) ID = INT $blob_path = TESTS_BASE_DIR . '/etc/lob/propel.gif'; $clob_path = TESTS_BASE_DIR . '/etc/lob/tin_drum.txt'; $sql = "INSERT INTO media (COVER_IMAGE,EXCERPT,BOOK_ID) VALUES (:p1,:p2,:p3)"; $stmt = $this->con->prepare($sql); $fileStream = fopen($blob_path, 'r'); $stmt->bindParam(':p1', $fileStream, PDO::PARAM_LOB); $stmt->bindValue(':p2', file_get_contents($clob_path), PDO::PARAM_STR); $stmt->bindValue(':p3', 5, PDO::PARAM_INT); $stmt->execute(); fclose($fileStream); Actual result: -------------- PDOException: SQLSTATE[HY000]: General error: 10007 Incorrect syntax near 'GIF89aÈ'. [10007] (severity 5) [(null)] ------------------------------------------------------------------------ -- Edit this bug report at https://bugs.php.net/bug.php?id=59375&edit=1