MySql float types a bit confused

[ade234uk]

One thing that has always puzzled me is float.

For instance say a user enter a price of 1,234.00 in a field and this gets entered in to mysql what should the float parameters be set at in MySQL so that it appears as 1,234.00 in the field?

Finally what would happen if a user entered 1.234.00 or 1234.00 how would this appear in the field, would mysql automatically insert , after the 1

I can see the benefit of having float values as it allows you to search.

[ade234uk]

I am going to be using double type instead.

So a user could enter 1243.00 and it appear in mysql as 1243.00

How can I stop a user entering 1,243.00?

[Roger_Ramjet]

Don't use floating point numbers for cash amounts. Floating points are 'approximate' values. Sure, when you round them to 2 decimals they come out as the right value, but try a search for say 49.95 and you'll find it does not match the float.

MySQL has the decimal data type for storing precise numeric amounts so use that.