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