My cmpany just started using BLOB data types. How do I deal with this using the C API? How can I find out the lenght of the returned data and display it?
The blob data, much like indirect file content, is not available as such to the API. You should convert() it to varchar in your select statement.
select Title,convert(Body,'varchar') Body,Date from TheTable