Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Storing Java Doubles in Oracle
Hi,
Does anyone have a recommendation on storing Java Doubles in Oracle.
The range of Java Doubles varies depending on who you ask but is in
the the region of 4.9E-324 to 1.79E308. Also they should correspond to
the SQL92 type DOUBLE PRECISION which has a range of
1.7976931348623157E+308 to -2.2250738585072014E-308 and 2.22507385
85072014E-308 to 1.7976931348623157E+308.
Oracle NUMBER only handles numbers in the range 1.0E-130 and 9.9E125.
So how do you store a Java Double such a 1.5E167?
You could of course use a string but it would be nice to store a
number as a number.
Thanks and Regards,
Paul McAdam.
paul_at_genient.com
Received on Fri Feb 22 2002 - 06:14:27 CST