Reading blob types

[m m]

Hi all

I need to store a big amount (more than 8kb) of data in one of the columns of a table. As I have seen it is not possible to use varchar for doing so and I need a type "TEXT" instead. But then, how can I read this value by using the Ndb API?

The values are inserted into the table, but when reading them, I don't get anything from the database:

NdbBlob *myBlobHandle= myOperation->getBlobHandle("namecolumn");

char buffer[100];
myBlobHandle->readData(buffer, 100);
if(myTransaction->execute( NdbTransaction::Commit ) == -1){
printf("Error %d );
myNdb->closeTransaction(myTransaction);
return 0;
}

printf("My buffer: %s", buffer);

And also, is there any way of doing it without having to specify the length of the column? Because it has a variable length and it isn't known in advance.

Thanks in advance

Best regards,
Marta