Hi Lester Caine,

I am really sorry that this is taking lot of yr time.

I had tried various combinations yesterday including this. This gives the old output "[BINARY]".

What I understand is, the blob content is obtained but these functions don't convert blob to string.

With regards,
Bala

--- In firebird-php@yahoogroups.com, Lester Caine <lester@...> wrote:
>
> Umberto Masotti wrote:
> > bala_karat ha scritto:
> >> Thanks again Lester Caine for yr valuable time.
> >>
> >> I tried the following:
> >>
> >> $host = "localhost:C:/BK_Share/file_test/FILE.FDB";
> >> ibase_connect($host, "SYSDBA", "masterkey");
> >> $result = ibase_query("select TEST from EMPLOYEEMASTER where EMPCODE = '002'");
> >> $data = ibase_fetch_object($result,IBASE_TEXT);
> >> $blob_hndl = ibase_blob_open($data->TEST);
> >>
> > No, you misunderstood. Quoting from manual " Passing *IBASE_TEXT* will
> > cause this function to return BLOB contents instead of BLOB ids".
> > So you should directly:
> > echo $data->TEST;
> > because you have a text not a blob-id.
>
> Yes - I was rushing so was not explaining very well :( Sorry!
>
> --
> Lester Caine - G8HFL
> -----------------------------
> Contact - http://lsces.co.uk/wiki/?page=contact
> L.S.Caine Electronic Services - http://lsces.co.uk
> EnquirySolve - http://enquirysolve.com/
> Model Engineers Digital Workshop - http://medw.co.uk//
> Firebird - http://www.firebirdsql.org/index.php
>