BLOB/CLOB Limitations
The following is a list of BLOB and CLOB limitations.
LOB columns cannot be updated through rowset objects.
Random order is not supported (i.e. DBPROP_ACCESSORORDER cannot be set to DBPROPVAL_AO_RANDOM).
For a rowset, only one LOB column can be bound to a storage object in an accessor.
If a LOB column in a rowset is to be bound to a storage object, it must be the highest
numbered ordinal in the binding of the accessor.
LOB columns are not searchable.
DB_E_BADSTORAGEFLAG when IRowset::GetData is called if a LOB column has been bound
with type defined as DBTYPE_IUNKNOWN, and IID_ISequentialStream specified with write
access.
The IStream interface is not supported. Only the ISequentialStream interface is supported.