OT : PDO Large Objects

[keith smith]

Hi,

I have a question about PDO.  I've written a class that I have tried to fashion after the Active Record design pattern. 

I'm hung up on one thing - Large Objects (LOBs).  http://www.php.net/manual/en/pdo.lobs.php

The documentation says :

At some point in your application, you might find that you need to store "large" data in your database. Large typically means "around 4kb or more", although some databases can happily handle up to 32kb before data becomes "large". Large objects can be either textual or binary in nature. PDO allows you to work with this large data type by using the PDO::PARAM_LOB type code in your PDOStatement::bindParam() or PDOStatement::bindColumn() calls. PDO::PARAM_LOB tells PDO to map the data as a stream, so that you can manipulate it using the PHP Streams API.

The examples all use ODBC which is Windows.  I'm using MySql.  The manual does not say this limitation is limited to Windows though.

I would like to use PDO with a couple of applications I am creating and the data will be larger than 4kb.

Is this a driver thing? 

Is it a PHP thing?

I know it is not a MySql limitation because I can define fields larger than 4kb.

I'm lost at what this means to me and how to apply this to my DB class.

Any help is much appreciated!!

Keith
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.phxlinux.org/pipermail/plug-discuss/attachments/20140404/7718f26c/attachment.html>