Path: text.usenetserver.com!out01b.usenetserver.com!news.usenetserver.com!in02.usenetserver.com!news.usenetserver.com!postnews.google.com!news2.google.com!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail From: Andy Hassall Newsgroups: comp.databases.oracle.server Subject: Re: modelling IPv6 as a number Date: Tue, 12 Dec 2006 23:29:03 +0000 Organization: Last minute panic Lines: 20 Message-ID: <48eun21c7nbevj9pspfvknctcof5551pfl@4ax.com> References: <1165952118.737337.35940@80g2000cwy.googlegroups.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Trace: individual.net mfa/bbclN48zKbW7FhXpFQ0YQLLnakkcJttdPwXL7URq7LKWvG X-Newsreader: Forte Agent 4.1/32.1088 Xref: usenetserver.com comp.databases.oracle.server:419078 X-Received-Date: Tue, 12 Dec 2006 18:28:18 EST (text.usenetserver.com) On Wed, 13 Dec 2006 09:18:31 +1100, Geoff Muldoon wrote: >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. One situation where the fact that an IPv4 address is a number shows up is in netmasks, for working out subnets and broadcast addresses. Presumably there are some similar operations that still apply to IPv6 addresses? -- Andy Hassall :: andy@andyh.co.uk :: http://www.andyh.co.uk http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool