Re: How to store 2^128 value in oracle

Anil wrote:
> I need to store a value equal to 2^128 in an oracle or sybase
> database.
> looks like neither of them support that big of a number.
> Any one has any idea on how to achieve this?
> Thanks,
> Anil

BINARY_DOUBLE is a 64-bit, double-precision floating-point number datatype. Each BINARY_DOUBLE value requires 9 bytes, including a length byte.

Note:
BINARY_DOUBLE and BINARY_FLOAT implement most of the Institute of Electrical and Electronics Engineers (IEEE) Standard for Binary Floating-Point Arithmetic, IEEE Standard 754-1985 (IEEE754). For a full description of the Oracle implementation of floating-point numbers and its differences from IEEE754, see the Oracle Database SQL Reference

If you can't do it within the Standard you will need to be creative.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org