INET6_NTOA
Converts an IPv6 or IPv4 internet address from its binary representation to its text representation.
Syntax
INET6_NTOA( bin_str )
Arguments
bin_str: binary string.
Return Type
String.
The return string is lowercase. It has a maximum length of 39 characters.
If the argument is not a valid address - returns NULL.
Examples
SELECT INET6_NTOA(UNHEX('0A000101')); **** +-------------------------------+ | INET6_NTOA(UNHEX('0A000101')) | +-------------------------------+ | 10.0.1.1 | +-------------------------------+
SELECT INET6_NTOA(UNHEX('48F3000000000000D4321431BA23846F')); **** +-------------------------------------------------------+ | INET6_NTOA(UNHEX('48F3000000000000D4321431BA23846F')) | +-------------------------------------------------------+ | 48f3::d432:1431:ba23:846f | +-------------------------------------------------------+
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 | +------------------------------------------------------------------------+