Hi there, I'm using MySql 3.23.?? with Connector/J on Win32. My Problem is that the database lets me UPDATE NOT NULL Fields with NULL-Values. This is not a special Java Problem!
For example: The Field "Name" in tbl_Names is declared NOT NULL. UPDATE tbl_Names SET Name = NULL WHERE ID = 23; ...works fine, but... INSERT INTO tbl_Names (Name) VALUES (NULL); ...throws an NOT NULL Exception!!! The Field "Name" is declared NOT NULL. This occurs during both, Java-Executes and manual Command Line Entry! Is there a way to configure mysql to throw an error while trying to update NOT NULL Fields with NULL??? Is that a bug that will be fixed someday? Thanx for your help! cya JayR -- +++ GMX - Mail, Messaging & more http://www.gmx.net +++ NEU: Mit GMX ins Internet. Rund um die Uhr für 1 ct/ Min. surfen! --------------------------------------------------------------------- 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