Re: How does Informix handle 64 bit data ??

INTEGER8 and SERIAL8 support 64-bit integers directly. FLOAT (in SQL) tends to be a 64-bit C double on most machines. Informix also has NUMERIC(32) for a 32 decimal digit number, which will be an integer in a MODE ANSI database (boo, hiss), or a floating point number with a range of about 10**-126..10**+126. I believe that a 64-bit integer only requires 20 decimal digits, so that's well within range and works on any version of Informix, whereas INTEGER8 and SERIAL8 are only available on later versions. Yours, Jonathan Leffler (johnl@informix.com) #include <witticism.h> >From: "Peries, Chaminda" <CPeries@dynasty.com> >Date: Wed, 6 Aug 1997 18:25:21 -0500 >X-Informix-List-Id: <list.15826> > > 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 ? > >TIIA PS: What's the second I in this, if the acronym is for Thanks In Advance? Or, what's this an acronym for?