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