Could anyone point me an example on how to retrieve blob data from a Mysql table using MySql C API?

I´m having troubles to retrieve with a standard mysql_query. I don’t know why, but it seens that only the 4 first bytes of tha blob collum are retrieved (exact the 4 first before a 0 char), just like a standard string. If I try to access the data after the 5o. byte, I got wrong data, and sometimes a crash because a illegal memory access. Its seens that C API only store the Blob data untill found a 0 char, just like a string, not all the binary data. The more bizzare thing, is that the mysql_fetch_lengths returns the exact BINARY size, not the string size. Very weird.

Any help would be much appreciated!!!

Thanks in advance

Cheers