Subject | Numeric, Decimal, Double Precision and Float data types. What and when to use? |
---|---|
Author | Theo Bebekis |
Post date | 2002-07-10T09:06:01Z |
Hi
could please someone give me more details, than those
provided by Interbase docs, about those data types?
Is there any white paper providing more info on the issue?
What do you recommend me to use?
Numeric and Decimal or the IEEE types (Double and Float)?
Does it depends? On what?
Also...
I see that MASTSQL database, provided with some of Delphi's demo apps,
uses DOUBLE PRECISION for ORDERNO and CUSTNO
of the ORDERS table to name a few cases.
Is that a wise decision? Why not just INTEGER?
Usually that kind of fields are of the INTEGER type, or not?
ORDERNO is the primary key where CUSTNO is foreign key to
CUSTOMER table.
I feel I'm missing something critical here...
Regards
(stressed today) Theo
PS. I use Firebird
-----------------------------------
Theo Bebekis
Thessaloniki, Greece
bebekis@...
teo@...
-----------------------------------
could please someone give me more details, than those
provided by Interbase docs, about those data types?
Is there any white paper providing more info on the issue?
What do you recommend me to use?
Numeric and Decimal or the IEEE types (Double and Float)?
Does it depends? On what?
Also...
I see that MASTSQL database, provided with some of Delphi's demo apps,
uses DOUBLE PRECISION for ORDERNO and CUSTNO
of the ORDERS table to name a few cases.
Is that a wise decision? Why not just INTEGER?
Usually that kind of fields are of the INTEGER type, or not?
ORDERNO is the primary key where CUSTNO is foreign key to
CUSTOMER table.
I feel I'm missing something critical here...
Regards
(stressed today) Theo
PS. I use Firebird
-----------------------------------
Theo Bebekis
Thessaloniki, Greece
bebekis@...
teo@...
-----------------------------------