On 27 Feb 2002, at 8:18, Baines, Dominic wrote: > If you immediately use the dump, this is fine if it is to be used > with MySQL but if you want to port it to another RDBMS the /N for > a NULL causes some 'issues'.
If you don't care about the difference between NULL and the empty string or 0, why not just set the columns to NOT NULL and be done with it? If you do care about the difference, how do you propose to preserve it when you're porting to another database? --Keith Filter fodder: SQL, query -- Keith C. Ivey <[EMAIL PROTECTED]> Washington, DC --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php