BLOB data field

Post Reply
sbeavers
Posts: 9
Joined: Wed Jan 31, 2001 7:31 pm

BLOB data field

Post by sbeavers »

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?
User avatar
mark
Site Admin
Posts: 5519
Joined: Tue Apr 25, 2000 6:56 pm

BLOB data field

Post by mark »

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
Post Reply