Subject | newbie question : NUMERIC and DECIMAL type difference |
---|---|
Author | Albert Loo |
Post date | 2003-02-20T05:42:07Z |
Hello,
I've checked with the Interbase 6 Data Defination Guide, chapter 4 on the
differences between NUMERIC and DECIMAL data type.
The only difference is :
DECIMAL - specifies 'at least' precision digits of precision to store.
NUMERIC - specifies 'exaltly' precision digits of precision to store.
I'm using JayBird JDBC to access the tables, for financial calculation.
It would be accessed into JDBC BigDecimal object.
What would be the correct choice of data type ?
Thanks in advanced.
Albert.
_________________________________________________________________
Add photos to your e-mail with MSN 8. Get 2 months FREE*.
http://join.msn.com/?page=features/featuredemail
I've checked with the Interbase 6 Data Defination Guide, chapter 4 on the
differences between NUMERIC and DECIMAL data type.
The only difference is :
DECIMAL - specifies 'at least' precision digits of precision to store.
NUMERIC - specifies 'exaltly' precision digits of precision to store.
I'm using JayBird JDBC to access the tables, for financial calculation.
It would be accessed into JDBC BigDecimal object.
What would be the correct choice of data type ?
Thanks in advanced.
Albert.
_________________________________________________________________
Add photos to your e-mail with MSN 8. Get 2 months FREE*.
http://join.msn.com/?page=features/featuredemail