INET6_ATON() function in MySQL

This function in MySQL takes a dotted representation of an IPv4 or IPv6 address and returns a binary string that represents the numeric value of the address in network byte order. If the input address is not a valid IPv4 or IPv6 address this function returns NULL.

Syntax :

INET6_ATON(expr)

Parameter :
This method accepts only one parameter.

• expr –
  Input IPv4 or IPv6 address represented by a string.

Returns :
It returns the numeric value of the address in VARBINARY data type: VARBINARY(16) for IPv6 addresses and VARBINARY(4) for IPv4 addresses.

Example-1 :
Checking the equivalent VARBINARY representation for the following address ‘10.16.25.0’ with the help of INET6_ATON Function. As it is a valid IPv4 address we will get result in VARBINARY form.

SELECT INET6_ATON('10.16.25.0')  
AS EquivalentAddressValue ;

Output :

EQUIVALENTADDRESSVALUE
0x0A101900

Example-2 :
Checking the equivalent VARBINARY representation  for the following address ‘2001:0db8:85a3:0000:0000:8a2e:0370:7334’  with the help of INET6_ATON Function. As it is a valid IPv6 address we will get result in VARBINARY form.

SELECT INET6_ATON('2001:0db8:85a3:0000:0000:8a2e:0370:7334')  
AS EquivalentAddressValue ;

Output :

EQUIVALENTADDRESSVALUE
0x20010DB885A3000000008A2E03707334

Example-3 :
Checking the equivalent VARBINARY representation for the following address ‘::0.5’ with the help of INET6_ATON Function. As it is not a valid IPv4 or IPv6 address we will get NULL.

SELECT INET6_ATON('::0.5')  
AS EquivalentAddressValue ;

Output :

EQUIVALENTADDRESSVALUE
0x