There appears to be a bug in the Win32 version of Mysql 2.23.49. When I try to read data in (using the "load data infile" syntax) that contains null values they are converted to "0"s. The fields in question are numeric, nulls allowed, default value is NULL. I tried coding them blank, "\N" and "NULL" (with and without quotes) and the result seems to be the same. Identical procedure (using \N) in the unix version 3.23.41 seems to work fine. This is a serious problem, as it is necessary to get the database working properly, with automated updates, on a Windoze system. I am surprised not to see any notes or bug reports on this issue. Any suggestions?
Karen --------------------------------------------------------------------- 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
