Re: How does Informix handle 64 bit data ??

Peries, Chaminda wrote: > > Hi folks !! > > > I'd like to know how Informix handles 64 bit data ? Are there any > data types in Informix that can handle 64 bit data ? Oracle has > something like NUMBER (38) { not quite sure }. Suppose I have a very > large number that I need to store hoe will I do this in Informix ? > Well, Informix has DEC_T structures (The decimal types.) This should give you the precision you want, albiet, the numeric calculations will be slower than native data types. Now if the OS is 32 bit, the double would be 64bit word length. And if the OS is 64 bit, then for sure all floating points would be atleast 64 bits. However you still have to deal with the randomness caused by floating point arithmetic in the mantissa. You would be better off with the decimal data type. What types of calculations are you planning? -Mikey -- #include <std_disclaimer.h> /* Mike Segel (MS385) */ #include <No_Spam.h> #ifdef OFFENDED_BY_CONTENT The author takes no responsibility for this post. Any resemblence to a coherent rational thought is purely coincidence. -The Management. #endif ***************************** Due to AGIS's Refusal to Act Responsibly We are blocking all of their domains at the packet level. This block will exist until AGIS modifies their policies to conform to existing RFCs and net community standards. We encourage all ISPs and domain holders to do the same. *****************************