Join the MemSQL Community Today
Get expert advice, develop skills, and connect with others.

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                                       |
+------------------------------------------------------------------------+

Related Topics