Problem with decimal values

[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 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