IP Address to Integer Converter (IPv4 & IPv6)

An IPv4 address is a 32-bit number written as four bytes: 192.168.10.37 is 192·2²⁴ + 168·2¹⁶ + 10·2⁸ + 37 = 3232238117, or 0xC0A80A25. Databases and logs often store the number because it takes 4 bytes instead of up to 15 characters and makes range queries (BETWEEN) fast. Use an unsigned 32-bit column: a signed one overflows above 127.255.255.255. An IPv6 address is a 128-bit number, too large for the integer types of most languages and databases, so the converter uses arbitrary-precision integers and also shows the high and low 64-bit halves.

The classic inet_aton() function — and therefore ping, curl and the URL parser of every browser — accepts more than dotted decimal: each part may be hexadecimal (0xC0.0xA8.0x0A.0x25) or octal with a leading zero (0300.0250.012.045), and with fewer than four parts the last one fills the remaining bytes, so 192.168.2597, 127.1 and the plain number 3232238117 are all valid hosts. These forms are recognised on input. They matter for security reviews: a filter that blocks 127.0.0.1 as text can be bypassed with 2130706433 or 017700000001.

For each address you also get the IPv4-mapped IPv6 form (::ffff:192.168.10.37, the way dual-stack sockets report IPv4 clients), the 6to4 prefix, the reverse DNS name and the address type. The reference panel shows the equivalent calls for the current value: INET_ATON(), INET_NTOA() and INET6_ATON() in MySQL and MariaDB, the inet type in PostgreSQL, ipaddress in Python, ip2long() in PHP. Nothing is sent to a server.