Edit report at https://bugs.php.net/bug.php?id=59375&edit=1
ID: 59375
Updated by: [email protected]
Reported by: kraven at kraven dot org
Summary: BLOB inserts broken
-Status: Open
+Status: Wont fix
Type: Bug
-Package: PDO_DBLIB
+Package: *General Issues
Operating System: Linux or Windows
PHP Version: 5.2.13
Block user comment: N
Private report: N
New Comment:
Due to this extension not seeing any activity since 2005, this issue will not be fixed. We are therefore closing this now.
Previous Comments:
------------------------------------------------------------------------
[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
lmpx.com only provides a reader for public news (NNTP) servers. It is not
affiliated with the servers or forums shown here and is not responsible for
the content of articles, which is written by their respective authors.