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]
>
>> Was the blob field created with SUB_TYPE 1 - since pdf is actually a
>> text based format?
> No, sub type 0
> Currently I am only testing with blob. So I created this data using FlameRobin manually - by typing some characters. My ultimate requirement is to read PDF files created by Delphi program and stored in blob.
>
>> Are you saying that the string you get is "[BINARY]" - in which case how
>> did you put data into the field?

Then PHP is working perfectly! I suspect THAT is what is stored ;)

If you want to play with text in blob fields, then you will need to
create a text blob field. To load binary data into a blob field I think
you have to use 'load blob from file' in FlameRobin, but there is a
discussion on the FlameRobin development list about how the in-line
editing works with blob files .... this is still work in progress.

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