INET6_ATON
Converts an IPv6 or IPv4 internet address from its text representation to its binary representation.
Syntax
INET6_ATON ( string )
Arguments
string: IPv6 or IPv4 network address as a string
Return Type
Binary string.
The length of the returned binary string will be 16 or 4 for IPv6 and IPv4 addresses respectively.
Returns NULL if the address is NULL or invalid.
Examples
SELECT HEX(INET6_ATON('10.0.1.1'));
****
+-----------------------------+
| HEX(INET6_ATON('10.0.1.1')) |
+-----------------------------+
| 0A000101 |
+-----------------------------+
SELECT HEX(INET6_ATON('48f3::d432:1431:ba23:846f'));
****
+----------------------------------------------+
| HEX(INET6_ATON('48f3::d432:1431:ba23:846f')) |
+----------------------------------------------+
| 48F3000000000000D4321431BA23846F |
+----------------------------------------------+
SELECT INET6_NTOA(INET6_ATON('2001:db8:8714:3a90::12'));
****
+--------------------------------------------------+
| INET6_NTOA(INET6_ATON('2001:db8:8714:3a90::12')) |
+--------------------------------------------------+
| 2001:db8:8714:3a90::12 |
+--------------------------------------------------+
SELECT HEX(INET6_ATON(INET6_NTOA(UNHEX('48F3000000000000D4321431BA23846F'))));
****
+------------------------------------------------------------------------+
| HEX(INET6_ATON(INET6_NTOA(UNHEX('48F3000000000000D4321431BA23846F')))) |
+------------------------------------------------------------------------+
| 48F3000000000000D4321431BA23846F |
+------------------------------------------------------------------------+