[!--quoteo(post=377884:date=May 28 2006, 01:30 PM:name=fenway)--][div class=\'quotetop\']QUOTE(fenway @ May 28 2006, 01:30 PM)
DOUBLE? Sounds like you should be using DECIMAL -- no need to have that much precision for what seems like a currency field.
Didn't know there was such a field. Double is to 16 places, right? Isn't it the slightly less precise version of Float?
I can't remember these things from when I used to write Java last year. [img src=\"style_emoticons/[#EMO_DIR#]/huh.gif\" style=\"vertical-align:middle\" emoid=\":huh:\" border=\"0\" alt=\"huh.gif\" /]
Can I store a Double number (ie, more than 2 decimals) in a Decimal field? If so, does it just truncate the rest of the numbers? Otherwise, is there a toDecimal ($var); type code somewhere? Also, is there really a difference... I mean, I don't really have a problem with it being in Double, but if it saves space or something, then I might change.