By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,504 Members | 1,884 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,504 IT Pros & Developers. It's quick & easy.

storing dbl_min in Oracle 9.2

P: n/a
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)
Jul 19 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.