different behaviour on windows and linux

On a text field , I have attached a number converter, just to make sure that user enters the number else gets an error message.

Things looks fine but it behaves differently on windows and linux os.

When I am running this application on windows if user enters

123456.46, it is stored as it is i.e 123456.46 in MySQL db.

However, if run this on linux and if user enters 123456.46 then it is stored in MySQL db as 123456.460000000006402842700481414794921875

I am not sure where the problem is. Can somebody guide me about it.

Thanks.

[573 byte] By [ndzpac] at [2007-11-26 11:14:42]