Subject Decimal field precision question
Author Jeff Dunlap
Dear FB Users:

I have installed the latest version of FB2 and created a Decimal field (3,3). Here is the applicable DDL:


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:


The Interbase 6 PDF states that DECIMAL(precision, scale), where precision = 1 to 18 digits of precision to store and scale = 0 to 18 is the number of decimal places that can be stored.

I am confused because in my case, DECIMAL(3,3) stores a max of 3 decimal places but why does it allow me to store precision in the millionth place?

Please advise,


Be a better Heartthrob. Get better relationship answers from someone who knows.
Yahoo! Answers - Check it out.

[Non-text portions of this message have been removed]