I am getting two different results for the same set of commands on two different versions of MySQL. Can anyone explain what the issue is?
CREATE TABLE `testdecimal` ( `rate` decimal(7,4) NOT NULL default '0.0000' ) ENGINE=MyISAM; INSERT INTO testdecimal SET rate=1468; select * from testdecimal; _____ version 4.1.12 1468.0000 version 5.0 999.9999 Shantanu Oak -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]