[DUG] Blob primer

[Paul McKenzie]

What are you trying to to do?
How are you, or should I say, to and from what are you trying to read/write blobs data ?

Regards
Paul McKenzie
SMSS Ltd.
Wellington
New Zealand


Phil Middlemiss wrote:
> 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
>>
>>
>>
> _______________________________________________
> Delphi mailing list
> Delphi at ns3.123.co.nz
> http://ns3.123.co.nz/mailman/listinfo/delphi
>