Re: modelling IPv6 as a number

From: Geoff Muldoon <geoff.muldoon_at_trap.gmail.com>
Date: Wed, 13 Dec 2006 09:18:31 +1100
Message-ID: <MPG.1fe9d5c5cd62bf259898bc@news.readfreenews.net>

maxwell.dana_at_gmail.com says...

> If I'm not mistaken, IPv6 requires 39 significant digits to represent
> each possible IP as an integer. Oracle's maximum is number(38). Has
> anyone devised a scheme to store the integer value of IPv6 in oracle?

Why ever would you store it as a number? It isn't an attribute to which you can naturally apply *numeric* functions, adding two IPv6 addresses together doesn't make much sense. Store it as a string.

GM Received on Tue Dec 12 2006 - 16:18:31 CST