On Fri, 2004-07-23 at 13:36, Terry Hampton wrote:
>
> Everyone,
>
> Just ran across an odd situation.
> I have defined a field:
>
> amount | money | not null default ''
>
> Works fine until the dollar amounts get
> very large - into the tens of millions.
> At that point, the actual amount stored
> becomes very unpredictable.
>
> I just saved a record via a simple
> front end App. I entered 56,000,000
> When I retrieved the record i got:
> $13,050,327.04 !!
>
> Any thoughts ?
The Money type is deprecated. It uses a floating point representation,
which is not good for precise values.
Use DECIMAL instead - e.g. DECIMAL(12,2)