MySQL Forums
Forum List  »  MyISAM

Re: Best Field Type for IP address?
Posted by: Ingo Strüwing
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
44124
October 12, 2005 12:19PM
Re: Best Field Type for IP address?
25845
October 17, 2005 01:37PM
39549
May 18, 2006 01:23PM
14395
October 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.