The decision to use NUMERIC or DECIMAL is not based on the precision,
but the scale. If it is not valid for the scale to be greater than what
you've defined, then use NUMERIC. If it is valid for the scale to be
larger than what you've defined, use DECIMAL.
Firebird usually won't care either way (it will expand the scale of both
types up to either 4, 9, or 18).

________________________________

From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Tomy Handaka
Sent: Tuesday, March 25, 2008 11:30 PM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Numerical data type



Hi all,

I have to save numerical records with 3 digits precision, what data type
should be used? What actually are the differences between numeric and
decimal in Firebird?

Thanks a lot.

Disclaimer: This message (including attachments) is confidential and may be privileged. If you have received it by mistake please notify the sender by return e-mail and delete this message from your system. Any unauthorized use or dissemination of this message in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change. RxStrategies, Inc. shall not be liable for the improper or incomplete transmission of the information contained in this communication or for any delay in its receipt or damage to your system. RxStrategies, Inc. does not guarantee that the integrity of this communication has been maintained nor that this communication is free from viruses, interceptions or interference.