PDO LOB Insert Loses Bytes

Binary package hint: php5-mysql

When inserting an 8262 byte image into the database using pdo lobs on ubuntu, only 7966 bytes are inserted. All 8262 bytes are inserted with the same script on windows. Note, debian does the same thing as ubuntu.

Create a mySQL table called files in a database called play with this structure:
CREATE TABLE `files` (
  `fileID` int(10) unsigned NOT NULL auto_increment,
  `type` varchar(50) collate utf8_unicode_ci NOT NULL default '',
  `data` blob NOT NULL,
  PRIMARY KEY (`fileID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

Put an image in a web directory.
Put this script in the same directory
<?php

/*this works fine*/
$imagesize = getimagesize('dm color logo copy.gif');
$fp = fopen('dm color logo copy.gif', 'rb');

/**
 * When Ubuntu inserts images into the database using pdo lobs, it cuts them off.
 * This same script works perfectly on Windows.
 * On Ubuntu, a 8262 byte image turns into 7966 bytes in the database
 * On Windows, it is stored with the correct size.
 */
$db = new PDO('mysql:host=localhost;dbname=play', 'db_username', 'db_password', array( PDO::MYSQL_ATTR_INIT_COMMAND=>'SET CHARACTER SET utf8;', PDO::MYSQL_ATTR_MAX_BUFFER_SIZE=>4194304 ) );
$prepared = $db->prepare('INSERT INTO `files` (`type`,`data`) VALUES (:type, :data)');
$prepared->bindParam(':type',$imagesize['mime'], PDO::PARAM_STR, 50);
$prepared->bindParam(':data', $fp, PDO::PARAM_LOB);
$prepared->execute();

/*this works fine*/
$id = $db->lastInsertId();

/*From other tests, this works fine on ubuntu*/
$prepared = $db->prepare('SELECT `type`, `data` FROM `files` WHERE `fileid` = :fileid');
$prepared->bindParam(':fileid',$id, PDO::PARAM_INT);
$prepared->execute();
$prepared->bindColumn(1, $type, PDO::PARAM_STR, 256);
$prepared->bindColumn(2, $lob, PDO::PARAM_LOB);
$prepared->fetch(PDO::FETCH_BOUND);
header("Content-Type: $type");
echo $lob;

?>

This script works on windows. It does not work on Ubuntu Feisty. It also does not work on MediaTemple's Grid Server which runs some version of Debian (which is where I originally discovered the problem).

For examples, see http://cowsandmilk.net/pdolob/pdolobtest.php for running on ubuntu and http://cowsandmilk.homeip.net/pdolob/pdolobtest.php for running on windows. http://sladm.org/pdolob/pdolobtest.php for running on media temple grid server

(or look at http://cowsandmilk.net/pdolob/ubuntuoutput.gif vs. http://cowsandmilk.net/pdolob/windowsoutput.gif vs. http://cowsandmilk.net/pdolob/mediatempleoutput.gif)

See http://php.net/pdo#pdo.lobs for examples on using lobs in pdo