Subject Re: [ib-support] Equivalent to TEXT field
Author Paul Reeves
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 ADODB
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 Borland's
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