Subject Re: [firebird-php] Re: Problem in retrieving BLOB data
Author Lester Caine
bala_karat wrote:
> Hello Lester Caine,
>
>> Do you have FlameRobin installed?
> Yes, in fact I created this test data using FlameRobin
>
>> What does FlameRobin show is in the blob field?
> [BINARY]

Yep - exactly what I am getting ...
I've created a two field table, blob sub_type 0 and blob sub_type 1 and
put text in both of them, and yes the '0' displays as [BINARY] so this
is not a PHP 'problem' but one of how Firebird returns data for that
type of blob ... I had to juggle a bit to create the sub_type 1 blob
field by NOT using the add field function, but the result is that I can
read the text from that field.

All my tables have sub_type 1 blobs which is why I've never seen a
problem, but we need to know what is going on with sub_type 0.

p.s. I loaded a couple of pdf's in the '1' and can see them quite
happily ...

--
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