Merit Network
Can't find what you're looking for? Search the Mail Archives.
  About Merit   Services   Network   Resources & Support   Network Research   News   Events   Home

Discussion Communities: Merit Network Email List Archives

North American Network Operators Group

Date Prev | Date Next | Date Index | Thread Index | Author Index | Historical

RE: Where did freeipdb IP utility site go?

  • From: Barry Shein
  • Date: Fri Jul 27 12:48:57 2007


 > 
 > > Are there any "good" tools for IPv6 address management?
 > 

Is there a "BCP" (convention, whatever) for storing IPv6 addresses
into SQL databases? Particularly where you need to mix them with IPv4
addresses.

I know postgresql has an ipv6 type but I was hoping for something more
portable. The best I could come up with was packed decimal(39) and
assume that if more than 32 bits are set it's IPv6 (ignoring the
special case of all zeros etc.) The other would be to just use 4
unsigned long ints similarly but it makes comparison and other ops
clunky.

-- 
        -Barry Shein

The World              | bzs@xxxxxxxxxxxx           | http://www.TheWorld.com
Purveyors to the Trade | Voice: 800-THE-WRLD        | Login: Nationwide
Software Tool & Die    | Public Access Internet     | SINCE 1989     *oo*




Discussion Communities


About Merit | Services | Network | Resources & Support | Network Research
News | Events | Contact | Site Map | Merit Network Home


Merit Network, Inc.