Subject | Re: Decimal field precision question |
---|---|
Author | jeff_j_dunlap |
Post date | 2007-09-27T18:21:40Z |
> INTEREST_RATE DECIMAL(3, 3)instance. What is confusing me is that these fields are allowing me
>
> I am trying to store values such as 2.575 or 95.555 percent for
to store much larger values such as:
>I read the IB6 documentation more carefully and it says:
> 1300000.532
DECIMAL precision specifies 'AT LEAST' precision digits to store.
NUMERIC precision specifies 'EXACTLY' precision digits to store.
When I tested, DECIMAL(3,3) AND NUMERIC(3,3) behave very much
differently when dealing with the size of the numeric to store. What
does not make sense is why DECIMAL allows you to store numbers in the
millionth place even though specifying DECIMAL(3,3)?
Thank you,
Jeff