Skip navigation links

MySQL Forums :: MyISAM :: Best Field Type for IP address?


Advanced Search

Re: Best Field Type for IP address?
Posted by: ()
Date: October 17, 2005 01:37PM

An IP address of the most commonly used IPV4 protocol is basically a 32-bit number. The INT data type would have the highest storage density for it. Depending of the form in which you have the address, you might need to convert it into na integer though. The disadvantage is that the number is inconvenient for humans when viewing the table contents with standard tools.

Options: ReplyQuote


Subject Views Written By Posted
Best Field Type for IP address? 40500 Jared Valarta 10/12/2005 12:19PM
Re: Best Field Type for IP address? 24598 10/17/2005 01:37PM
Re: Best Field Type for IP address? 37827 Me Me 05/18/2006 01:23PM
Re: Best Field Type for IP address? 13807 Chris C 10/02/2006 09:34AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.