NDB API Datatypes

[Mike Cress]

I am using the new-style API (e.g.NdbRecords, not the old/simple api) and I am having difficulty determining what my structures should be for various NDB datatypes. Through lots of Googling and trial-and-error, I have discovered that I can query a VARCHAR field by creating a struct with a char array member whose size is strlen()+1 (for length prefix). For example:

create table test (acct varchar(50) not null primary key );

struct Rowdata
{
char acct[51];
}

Column...
RecordSpec...
NdbRecord...
..etc..

My current frustration is with DATETIME. I have read this post (http://forums.mysql.com/read.php?25,290323) but when attempting to add a member to the struct of type uint64_t, my call to createRecord returns NULL. This was what happened when I did not have the VARCHAR members set up correctly. I have also attempted to use char[8] unsuccessfully.

First question: how can I represent datetime data in a struct that won't fail when I call createRecord(..)?

Second question: for each new type I need to use, what can I do to discover this information for myself?


Thank you,

Mike