XPost: comp.databases.oracle.misc   
   From: j_c_w_h_u_i@hot_mail.company   
      
   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)   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)