INET6_
On this page
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.
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 |
+------------------------------------------------------------------------+Related Topics
Last modified: February 27, 2023