whats the difference?
I mean i looked it up in the manual bit can't see what difference the 2 have in practical terms. I'm using DEICIMAL for a price field, is this the best type to use?
[SOLVED] DOUBLE vs DECIMAL
Moderator: General Moderators
[SOLVED] DOUBLE vs DECIMAL
Last edited by irealms on Thu Nov 04, 2004 3:50 am, edited 1 time in total.
Difference.
Hi,
Semantically they can be used interchangeably.
From my c/c++ experience all i can say is: Decimal is stored as strings and will take longer to process in calculations, however, Double’s are sometimes prone to rounding errors especially with extreme values.
If I were going to store currency, I would probably go for a Decimal type field. In most instances I would not bother about it.
Semantically they can be used interchangeably.
From my c/c++ experience all i can say is: Decimal is stored as strings and will take longer to process in calculations, however, Double’s are sometimes prone to rounding errors especially with extreme values.
If I were going to store currency, I would probably go for a Decimal type field. In most instances I would not bother about it.