AAA> Hi,

>> - if the subtype of the BLOB field is >= 0 - this is LONGVARBINARY;
>> - if the subtype of the BLOB field is < 0 - this is BLOB.
>>
>> What do you think?

AAA> I agree. I think that is the best solution.

from Interbase 6 "Data Definition Guide", page 78-79:
-------------------------------------------------------------------
user defined blob types has a subtype of negative number...

...subtypes:

0: binary data
1: text
2: binary language representation (maybe this should be a serialized
object???)
3: Access Control List
4: reserved
5: encoded description of a table's current metadata
6: description of a multi-database transaction that finished
irregularly

-------------------------------------------------------------------

I suppose subtypes 2-6 are used internally by Firebird/Interbase, but
it does not mean anything else...

Daniel