Path: text.usenetserver.com!out02a.usenetserver.com!news.usenetserver.com!in02.usenetserver.com!news.usenetserver.com!news-out.octanews.net!indigo.octanews.net!authen.yellow.readfreenews.net.POSTED!not-for-mail From: Geoff Muldoon Newsgroups: comp.databases.oracle.server Subject: Re: modelling IPv6 as a number Date: Wed, 13 Dec 2006 09:18:31 +1100 Message-ID: References: <1165952118.737337.35940@80g2000cwy.googlegroups.com> Organization: Southern Cross University MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-15" Content-Transfer-Encoding: 7bit User-Agent: MicroPlanet-Gravity/2.60.2060 Lines: 11 NNTP-Posting-Date: 12 Dec 2006 16:17:53 CST X-Trace: DXC=S?Y^e1:92HJm9[WKoTD2jJ]AGWjF5PjPI465Ue@WB_5OgFYi?58_OhAI0V42BOHUiGbI8A6IiUbTD:n0^ha1E`oGlJ\V2XbPiiH Xref: usenetserver.com comp.databases.oracle.server:419066 X-Received-Date: Tue, 12 Dec 2006 17:17:53 EST (text.usenetserver.com) maxwell.dana@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