As described previously in Inserting LOB Data, LOB data is relatively large by nature, therefore, retrieving LOB data, like inserting LOB data, will likely also be done in parts, rather than reading the whole LOB in one operation.
To retrieve LOB data, use a series of SQLGetData calls.