I'm converting an old textual database to MySQL with Rose. MySQL has 3 options for a date: a date 0000-00-00 NULL
My scripts currently have a date either as "" or a date. So presumably my empty date "" needs to be mapped to either 0000-00-00 or NULL in MySQL. I've searched the documentation without finding anything and although there are a couple of threads on this subject it's still not clear to me. In my date fields in MySQL schema, is it best for me to allow NULL and then make empty dates map to NULL? Or is it best to disallow NULL and then make empty dates map to 0000-00-00? And then the followup question, if I try to set a date of "" with Rose, this doesn't work, naturally. So is the right thing to do to convert any dates of "" to 0000-00-00 or NULL (depending upon the answer to Q1) before doing the assignment or can Rose do something more clever? And final question, how DO you set a field to NULL with Rose, anyway? thanks very much for any pointers/advice, James. ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys-and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Rose-db-object mailing list Rose-db-object@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/rose-db-object
