Re: DECIMAL TYPE in ESQL-C-Programms

Posted in 1997

Art S. Kagel — Mon, 21 Jul 1997 14:00:47 -0400 — source: Informix-list mailing list archive (1991-1998)

Kirschjm wrote: > > It's urgent !!! > > Does anybody know what kind of problems you get, if you fetch > DECIMAL(12.2) values into host-variables of the data type DOUBLE ? > (INFORMIX 7.12) > Can the results of of summations and multiplications be wrong ? > Is there any impicit conversion ? No the results cannot be wrong but you must watch out for overflows since DECIMAL can handle 32 digits while double only handles 15 digits of precision. Some DECIMAL values are not exactly representable in IEEE floating point and you may lose precision. Art S. Kagel