RE: [PEAR] BLOBS in DB and MDB
| From: | Lukas Smith | Date: | Thu, 20 Mar 2003 12:14:52 +0000 |
| Subject: | RE: [PEAR] BLOBS in DB and MDB | ||
| References: | 1 | Groups: | php.pear.general |
| Request: | Send a blank email to pear-general+get-4332@lists.php.net to get a copy of this message | ||
> From: Jeroen Houben [mailto:jeroen@terena.nl]
> Sent: Thursday, March 20, 2003 11:08 AM
> To: PEAR
> Subject: [PEAR] BLOBS in DB and MDB
>
> Hi,
>
> How do PEAR::DB and PEAR::MDB handle BLOB fields? Could someone give a
> quick example of how you would insert and select BLOBS using DB/Mdb ?
Please take a look at http://www.backendmedia.com/MDB/docs/.
I recently updated the links in the lower left corner. The second to
last link is a reference to my PHP Mag article that can be read freely
from their homepage. There is a section on LOB handling in there.
> How do people store their binary data (pdf's, word docs etc) in
> Postgres? I noticed you can store it in a TEXT field (up to 1GB IIRC),
> but also using OID's. Which techniques do MDN/DB use?
OID's for both CLOB's and BLOB's.
Regards,
Lukas