Have a problem where numbers such as 10,999.99 is rounded up to 11,000 by CCK.

10,999.49 is rounded to 10,999.5
10,999.50 is kept at 10,999.5
10,999.51 is rounded to 10,999.5
10,999.67 is rounded to 10,999.7
10000.99 is rounded to 10,001
65000.99 is rounded to 65001

Everything under 10,000 seems to act correctly and no rounded happens.

Comments

jamestombs’s picture

jamestombs commented

Appears to be down to MySQL. When using float as the column type, numbers larger than 10,000 with decimals are rounded.

karens’s picture

karens commented
Status: Active » Closed (duplicate)

This is a duplicate of a very very old issue. This is a problem with the 'float' type, which is the only available type in D5. In D6 we introduce a new 'decimal' type that handles big ints correctly. This is fixed in D6 and will not get fixed in D5.