On Wed, 07 May 2008 20:43:45 +0200, <FeelLikeANut@gmail.com> wrote:

> I'm using the example on the following page for selecting and fetching
> a large data object. <http://publib.boulder.ibm.com/infocenter/db2luw/
> v9/index.jsp?topic=/com.ibm.db2.udb.apdv.php.doc/doc/t0023504.htm>
>
> Here's what I've tried:
>
>
> $avatarFile = tempnam('', '');
> $avatarSteam = fopen($avatarFile, 'wb');
>
> $stmt = $dbh->prepare('SELECT user_avatar FROM users WHERE user_id =
> 29');
> $stmt->execute();
> $stmt->bindColumn('user_avatar', $avatarSteam, PDO::PARAM_LOB);
> $stmt->fetch(PDO::FETCH_BOUND);
>
> var_dump($coverSteam);
>
> Ideally, $coverSteam should be a stream to a temporary file containing
> the large data, but instead it's coming out as a string. And holding
> the large data as a string in memory is exactly what I'm trying to
> avoid. What am I doing wrong and how do I fix it? (I'm using SQLite,
> in case it matters.)

I'll see if I can reproduce this tomorrow, in the mean while: a big report
that isn't yet solved seems to be filed:
http://bugs.php.net/bug.php?id=40913
--
Rik Wasmus