php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #57008 Blob buffer size too small?
Submitted: 2006-05-10 08:04 UTC Modified: 2006-05-19 08:49 UTC
From: vlads at krediidiinfo dot ee Assigned: kraman (profile)
Status: Closed Package: PDO_INFORMIX (PECL)
PHP Version: 5_1 CVS-2006-05-10 OS: Suse Enterprise Linux 9
Private report: No CVE-ID: None
 [2006-05-10 08:04 UTC] vlads at krediidiinfo dot ee
Description:
------------
$db = new PDO('informix:database=krediit; server=db_krediit; protocol=onsoctcp; EnableScrollableCursors=1', 'usr', 'pwd');
$db->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION );
$db->setAttribute( PDO::ATTR_CASE, PDO::CASE_LOWER );

$stmt = $db->prepare('select data from bkaart_xml where eregnr = ?');
$stmt->execute(array("10256137"));

$stmt->bindColumn(1, $bkaart_data, PDO::PARAM_LOB);
$row = $stmt->fetch(PDO::FETCH_BOUND);

echo '<pre>';
echo htmlentities($bkaart_data);
echo '</pre>';

The data size in the blob column is 58759 bytes.
I get the same result also with streams. 

PHP Version I use is 5.1.4 (can't select this version in reporting form!), IDS 10.00UC4, CSDK 2.90.UC4
(Did not work with previous versions either).

I think something is wrong with the drivers internal buf size.

Expected result:
----------------
Value contained in blob column

Actual result:
--------------
Some part of the value contained in blob column, but it is truncated and contains garbage in the end

Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2006-05-16 16:25 UTC] kraman at gmail dot com
Hi, can you please verify reproduction of the bug with the latest alpha release of pdo_informix.

Thanks
 [2006-05-19 08:48 UTC] vlads at krediidiinfo dot ee
Everything works fine now (both with PDO::ATTR_STRINGIFY_FETCHES and also with streams). Thank you!
 [2006-05-19 08:49 UTC] vlads at krediidiinfo dot ee
closing
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Thu Mar 28 12:01:27 2024 UTC