According to multiple sources, the ranges of a FLOAT are:
Positive numbers: Min Value: 1.175494351E-38 and Max Value: 3.402823466E+38
Negative Numbers: Min value: -3.402823466E+38 and Max Value: -1.175494351E-38
Given that, why can I successfully insert into an Informix SMALLFLOAT a value of -5.6051938E-45, which is greater than the maximum value?
Yet, I can not insert a SMALLFLOAT value of 3.4028234E+39, which is greater than the maximum value:
I've experimented a little by decreasing the exponent for negative numbers and when the exponent gets to -46, the update fails.
Sure seems to me that this is a bug in Informix.
Appreciate any input!
------------------------------
Thanks,
Rick Spagna
Optim Development Director
UNICOM Global
------------------------------