Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Is Oracle's conversion to/from IEEE lossless?
My guess is yes. Oracle stores the numbers with up to 38 digits of
precision. It stores the numbers in base 100 with an offset so number
storage is quite efficient.
Jim
"Brian Smith" <brian-l-smith_at_uiowa.edu> wrote in message
news:60360d48.0111270246.397b6051_at_posting.google.com...
> I understand that Oracle doesn't store numbers in IEEE 754-1985
> format. But Can Oracle represent every IEEE 754-1985 double- and
> single- precision number? For example, if I have a Java "double", can
> I store it in Oracle and then retrieve it and get the same exact
> value? What limitations are there to do thing this?
>
> I searched on groups.google.com for an answer to this but I couldn't
> find a definitive one.
>
> Thanks,
> Brian
Received on Tue Nov 27 2001 - 05:19:38 CST