-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Stephen Fromm wrote:
> It appears that if I try to insert an illegal value into an INT field, the > value is set to 0 instead of NULL, even though the field has NULL as a > default. > > Is this documented behavior, and if so, what's the rationale? Yes. It's documented (along with the rationale) at http://www.mysql.com/doc/en/constraint_NOT_NULL.html -Mark - -- For technical support contracts, visit https://order.mysql.com/?ref=mmma __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mark Matthews <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, SW Dev. Manager - J2EE/Windows /_/ /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA <___/ www.mysql.com -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE+12UntvXNTca6JD8RAiRDAJ9IMOu6dBkXU4lv8SM1kOp6D69uEACgtXgw brHdZIn8j/Fqc11YJPkHIo4= =eT17 -----END PGP SIGNATURE----- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]