Re: Problem with decimal values

2005-10-26 Thread Rhino
- Original Message - From: "Tatjana Cukic" <[EMAIL PROTECTED]> To: "MYSQL ANSWERS" Sent: Wednesday, October 26, 2005 4:05 AM Subject: Problem with decimal values > Hi People, > > it is strange, i am using MySQL version 4.1 (so dont > expect some

Problem with decimal values

2005-10-26 Thread Tatjana Cukic
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 9