Subject RE: [ib-support] Equivalent to TEXT field
Author Darryl VanDorp
is a php based DB abstraction layer.
Since php has different implentations for each
database ADODB (as is phplib) gives a common
interface to allow cross db portability as well
as 1 learning curve.

What your saying is ADODB would have to be
made smart enough to take a select statment,
determine which columns are blob's and process them
as appropriate. (which i dont' think it is now)



-----Original Message-----
From: Paul Reeves [mailto:paul@...]
Sent: Thursday, October 04, 2001 10:31 AM
Subject: Re: [ib-support] Equivalent to TEXT field

Darryl VanDorp wrote:
> As for middleware, i'm developing some web stuff and
> am using ADODB and it doesn't seem to do anything
> special to extract blob's from simple select statments.

Hmmm. I'm not familiar with ADODB. However, I'd guess that you are using an
IB/Fb specific driver with it. That is the layer where the Blob API calls
should be implemented. Typically there should be a call(s) to make from
to specifically read each blob based on the blob id returned in the select

As a quick reality check I just tested the IBPhoenix ODBC driver via
SQL Explorer. It had no problem showing blobs in the blob window while I
scrolled through the dataset. I believe ADODB is a layer over ODBC so the
underlying technology should be there for you to read blobs fairly easily.


Paul Reeves
taking InterBase further

To unsubscribe from this group, send an email to:

Your use of Yahoo! Groups is subject to