I didn't see anyone else reply, so I will give you my thoughts.
I thought one of the "list gurus" would give you a much better answer than I
could so I waited.
Assuming that with two decimal places, you are doing something monetary.
But this applies whenever you want fixed decimal places, too.
I
You have a bigger problem than that.
All your 409s changed to 509s.
Lonny Byrd wrote:
Description:
Mysql arbitrarily rounds large floats
How-To-Repeat:
create table temp (
id int unsigned not null auto_increment primary key,
amount float(8,2)
);
insert i
