IPV6_STRING_TO_NUM_OR_NULL

Description

The reverse function of IPv6NumToString, it takes an IP address String and returns an IPv6 address in binary format.

Alias

• INET6_ATON

Syntax

IPV6_STRING_TO_NUM_OR_NULL(<ipv6_string>)

Parameters

Parameter	Description
<ipv6_string>	An IPv6 address of type String

Return Value

Returns an IPv6 address in binary format.

• If an illegal IP address is entered, NULL is returned.
• If the input string contains a valid IPv4 address, returns its IPv6 equivalent.

Example

select hex(ipv6_string_to_num_or_null('1111::ffff')) as r1, hex(ipv6_string_to_num_or_null('192.168.0.1')) as r2, hex(ipv6_string_to_num_or_null('notaaddress')) as r3;

+----------------------------------+----------------------------------+------+
| r1                               | r2                               | r3   |
+----------------------------------+----------------------------------+------+
| 1111000000000000000000000000FFFF | 00000000000000000000FFFFC0A80001 | NULL |
+----------------------------------+----------------------------------+------+