--- In IBObjects@yahoogroups.com, "colincoleman2002"
<yahoogroups@...> wrote:

>
> I have a Firebird 1.5.4 dialect 3 database ,mounted on a Visat PC,
> running Firebird 2.1, with binary information stored as BLOB

SUBTYPE 2

> SEGMENT SIZE 4096 (from Ibexperts), I am using Delphi 2007, and

using

> the ODBC connection (2.00.00.144) and the ADOdataset i can

successfully

> stream the blob to a file (test.jpg) this work perfectly !
>
> But using the IBO Tdataset components TIBOQuery or TIBOTable the

output

> is truncated. I am using IBO version 4.8.7
>
> How can i use my favorite Dataset components (IBO) to read these

blobs.

>
> Regards
> Colin Coleman
>

Hi Helen,
You are spot on !!, we are very simply trying to store jpegs in the
Firebird 2.1 DB and then display them in a Delphi 2007 form. What
BLOB type would you reccomend using for this type of storage ?

We only use the TIBOdataset components, Can i use the TIBOQuery to
read/write these Blobs ? and if so how.

you mentioned TIB_JPEGImage would this mean i would have to rewrite
my whole application to use the TIB_ components ?

Great help....thanks
Colin