How to get BLOB data using MySQL connector C++

[Bingjun Zhang]

HI all,

I am pretty new to MySQL world, but know some basics.

I was trying to get BLOB data using MySQL C++ connector. However, there is no function getBlob() in class ResultSet.

Could any one give me some suggestions on how to get BLOB data from a ResultSet object below:

std::auto_ptr< sql::ResultSet > res(stmt->executeQuery("SLELECT content FROM audio_table WHERE id='1'"));

where content is the column of BLOB type, and audio_table is a table storing lots of audio files in the content column.

Will appreciate any input! Thanks a lot!