[DUG] Blob primer

[Paul McKenzie]

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
>