Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: modelling IPv6 as a number

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US