Subject Re: [Firebird-Architect] blobs causes table fragmentation.
Author Jim Starkey
Leyne, Sean wrote:

>
>
>>Probably I would introduce new data type BINARY(n) of maximum size
>>32000 bytes content of which would be stored on the database page
>>(that would be VARCHAR type without all character information, like
>>charset, collation, etc.) whose content is sent over the wire together
>>with the content of the rest of the fields. People that need objects
>>without upper bound should use BLOBs that in this case would be always
>>stored separately.
>>
>>
This is a truly dreadful idea. Absolutely retrograde.

Computers should know how to best organize their innards. Introducing a
crock like this is simultaneously admitting failure while make success
impossible.