Hi People, it is strange, i am using MySQL version 4.1 (so dont expect some bugs) on Windows 2000, and if i create a field (e.g. temperature) as
temperature decimal(4,3) if i wanna insert the value 100, it is storing as 99.999 does anybody knows the reason why doesnt show it as 100.000 but as 99.999 when my size is defined as 4 but not 2 Thanks a lot! Regards, Tatjana __________________________________ Yahoo! FareChase: Search multiple travel sites in one click. http://farechase.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]