List:Cluster« Previous MessageNext Message »
From:Tim Schuh Date:November 11 2005 8:47pm
Subject:Re: Best Fieldtype to store IP address...
View as plain text  
Evan Borgstrom wrote:
> 	The same way the kernel deals with them; int(10) unsigned. To convert a
> dotted quad string into int(10) use the following:
> 
> Using 192.168.10.50:
> 192 + (168 * 2^8) + (10 * 2^16) + (50 * 2^24) = 839559360
> 
> 	This is real handy if you're doing low level socket stuff and storing
> addresses in the database.
> 
> -Evan

This is how I've stored IP information in the past.  It also makes it 
much easier to sort by IP, etc.  However I believe you mean

(192 * 2^24) + (168 * 2^16) + (10 * 2^8) + 50 = 3232238130
Thread
Best Fieldtype to store IP address...Cory @ SkyVantage11 Nov
  • Re: Best Fieldtype to store IP address...Evan Borgstrom11 Nov
    • Re: Best Fieldtype to store IP address...Tim Schuh11 Nov
    • Re: Best Fieldtype to store IP address...Michael Stassen11 Nov
  • Re: Best Fieldtype to store IP address...pekka11 Nov