[DUG] Blob primer

[Phil Middlemiss]

Thanks Paul, I'm using the blobs to store binary data, not text. I've 
finally found something that covers what the subtypes are, but still 
nothing that shows how to read/write to them using sql.

Phil.

Paul McKenzie wrote:

> I don't know about firebird, but IB sux...
> If you are using it for pure binary data e.g. Images etc. then there 
> is not much choice, and it is usable.
> Subtypes are used for defining what type of Blob data eg. Text.
> If you are trying to use Blobs for storing text - My advice - avoid 
> this at all costs!
> Even though there is a subtype for text it is useless - we couldn't 
> get SQL to interpret the text.
> I ended up writing a UDF to convert our blobs out into VarChars
> There are various UDF's around for dealing with Blob Text - either 
> buggy or just don't work!
> HTH.
>
> Regards
> Paul McKenzie
> SMSS Ltd.
> Wellington
> New Zealand
>
>
> Phil Middlemiss wrote:
>
>> Could anyone give me a link to a "how-to" about blobs? I'm using D6 
>> with firebird - there is no GUI (it's a service) so I would like to 
>> just use SQL if possible.
>>
>> Having not used blobs before I'm wondering:
>> - what is a subtype? The Interbase documentation assumes you know
>> - what is a good size for the segment length
>> - how to specify binary data in a sql - if it's actually possible.
>> - if I can't just use sql then what's the best way?
>>
>> Phil.
>>
>> _______________________________________________
>> Delphi mailing list
>> Delphi at ns3.123.co.nz
>> http://ns3.123.co.nz/mailman/listinfo/delphi
>>
>
> _______________________________________________
> Delphi mailing list
> Delphi at ns3.123.co.nz
> http://ns3.123.co.nz/mailman/listinfo/delphi
>
>
>