I have problems on storing dbl_min into a "DOUBLE PRECISION" column in
Oracle 9.2 (via ODBC). dbl_min is 2.2250738585072 014E-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)
Oracle 9.2 (via ODBC). dbl_min is 2.2250738585072 014E-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)