Subject Re: Decimal field precision question
Author jeff_j_dunlap
> INTEREST_RATE DECIMAL(3, 3)
>
> I am trying to store values such as 2.575 or 95.555 percent for
instance. What is confusing me is that these fields are allowing me
to store much larger values such as:
>
> 1300000.532

I read the IB6 documentation more carefully and it says:

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