Re: Using CoCreateGuid (Unique ID gen) in ORACLE - How can it be?

One bit may be the sign?

Martin

Alan Hopkins wrote:
>
> Using the Microsoft API to generate 128 bit unique ids (positive integer)
> yields a number that has from 1 to 39 significant digits to the left of
> decimal.
>
> A NUMBER datatype in ORACLE can only be 38.... What am I missing?
>
> I could use a VARCHAR(16), but the front-end application would incur some
> additional overhead (hashing the string) and plus, it's going to take up
> more memory.
>
> Again, what am I missing in this picture?
Received on Tue Jan 18 2000 - 14:10:38 CST