Which MySQL datatype to use for an IP address

Question

Possible Duplicate    How to store an IP in mySQL       I want to get the IP address from   SERVER  REMOTE ADDR   and some other   SERVER variables  which datatype is the right one for this   Is it VARCHAR n

User · Answer

For IPv4 addresses  you can use VARCHAR to store them as strings  but also look into storing them as long integesrs INT 11  UNSIGNED   You can use MySQL s INET ATON    function to convert them to integer representation   The benefit of this is it allows you to do easy comparisons on them  like BETWEEN queries   INET ATON   MySQL function

User · Answer

Since IPv4 addresses are 4 byte long  you could use an INT  UNSIGNED  that has exactly 4 bytes    ipv4  INT UNSIGNED   And INET ATON and INET NTOA to convert them   INSERT INTO  table    ipv4   VALUES  INET ATON  127 0 0 1     SELECT INET NTOA  ipv4   FROM  table     For IPv6 addresses you could use a BINARY instead    ipv6  BINARY 16    And use PHP   s inet pton and inet ntop for conversion    INSERT INTO  table    ipv6   VALUES     mysqli real escape string inet pton  2001 4860 a005  68          SELECT  ipv6  FROM  table    ipv6   inet pton  row  ipv6

User · Answer

You have two possibilities  for an IPv4 address      a varchar 15   if your want to store the IP address as a string   192 128 0 15 for instance  an integer  4 bytes   if you convert the IP address to an integer   3229614095 for the IP I used before     The second solution will require less space in the database  and is probably a better choice  even if it implies a bit of manipulations when storing and retrieving the data  converting it from to a string    About those manipulations  see the ip2long   and long2ip   functions  on the PHP-side  or inet aton   and inet ntoa   on the MySQL-side

[php] Which MySQL datatype to use for an IP address?

Examples related to php

Examples related to mysql

Examples related to types

Examples related to ip-address