storing dbl_min in Oracle 9.2

From: jcwhui <j_c_w_h_u_i_at_hot_mail.company>
Date: Wed, 19 May 2004 17:42:28 GMT
Message-ID: <Xns94EE6CECF98Ajcwhui@198.161.157.145>

I have problems on storing dbl_min into a "DOUBLE PRECISION" column in Oracle 9.2 (via ODBC). dbl_min is 2.2250738585072014E-308 in case you don't know.

The problem is Oracle rounds it to 0.0. Our application uses DBL_MIN as the NaN for any doubel values, but 0.0 is a valid value to us.

I am asking for opinions on how to deal with this. The one workaround I have is to store a special value instead, and when I retrieve it back I convert this special value back to DBL_MIN. For example, I can use FLT_MIN which is 1.17549435E-38F, or 2B.

Is this a sound approach? Any other suggestion? Thanks!!

Will (jcwhui hotmail)

Received on Wed May 19 2004 - 12:42:28 CDT