©SQL :: Manager
HomeProgram InformationTechnical detailsFree downloadDonate for a cup of coffee
myway SQL Manager for MySQL and MariaDB, Download on Uptodown
SQL functionMySQLMariaDB

The INET6_NTOA SQL Function in MySQL and MariaDB - Convert binary to IPv6 address

INET6_NTOASyntax:INET6_NTOA(Binary string)
Return value:CHAR
Function type:Miscellaneous function
Function Description

The INET6_NTOA() function converts a "Binary string" to an IPv6 address.

If the "Binary string" argument is invalid or NULL, the INET6_NTOA() function returns NULL.


INET6_NTOA() is the inverse function of INET6_ATON().

SQL Examples for the INET6_NTOA function

 1
 2
 3
 4
 5
 6
 7
 8
 9
10


SELECT INET6_NTOA(unhex('FE800000000000008ADE7CFFFEF7E3A5'));
SELECT INET6_NTOA(unhex('2A023030081ED48DCD91E9725C6B90A8'));
SELECT INET6_NTOA(unhex('00000000000000000000000000000001'));
SELECT INET6_NTOA(unhex('7F000001'));

SELECT INET6_NTOA('');
SELECT INET6_NTOA(2130706433);
SELECT INET6_NTOA(null);
INET6_NTOA(unhex('FE800000000000008ADE7CFFFEF7E3A5'))
varchar(39) BINARY
fe80::8ade:7cff:fef7:e3a5
INET6_NTOA(unhex('2A023030081ED48DCD91E9725C6B90A8'))
varchar(39) BINARY
2a02:3030:81e:d48d:cd91:e972:5c6b:90a8
INET6_NTOA(unhex('00000000000000000000000000000001'))
varchar(39) BINARY
::1
INET6_NTOA(unhex('7F000001'))
varchar(39) BINARY
127.0.0.1
INET6_NTOA('')
varchar(39) BINARY
NULL
INET6_NTOA(2130706433)
varchar(39) BINARY
NULL
INET6_NTOA(null)
varchar(39) BINARY
NULL
The examples were created with the MyWAY SQL manager: Download

How to use the INET6_NTOA() function in MySQL and MariaDB databases

In MySQL and MariaDB the INET6_NTOA() function is used to convert an IPv6 address from its numeric representation to its textual form. The function takes a binary string representing the numeric IPv6 address as an argument and returns the corresponding IPv6 address in text format, for example for display purposes or to use in queries and to use comparisons where specific ranges of IPv6 addresses can be filtered or retrieved. String operations can also be performed in this way, or certain parts of the address can be extracted.
IFIFNULLINET6_ATONINET6_NTOAINET_ATONINET_NTOAINSERT

Further MySQL und MariaDB SQL Miscellaneous functions

BIN_TO_UUIDBIN_TO_UUID(Binary string [, Swap])
More about BIN_TO_UUID Function

GET_LOCKGET_LOCK()

INET6_ATONINET6_ATON(String)
More about INET6_ATON Function

INET_ATONINET_ATON(String)
More about INET_ATON Function

INET_NTOAINET_NTOA(Value)
More about INET_NTOA Function

IS_FREE_LOCKIS_FREE_LOCK()

IS_IPV4IS_IPV4(String)
More about IS_IPV4 Function

IS_IPV4_COMPATIS_IPV4_COMPAT(String)

IS_IPV4_MAPPEDIS_IPV4_MAPPED(String)

IS_IPV6IS_IPV6(String)
More about IS_IPV6 Function

IS_USED_LOCKIS_USED_LOCK()

IS_UUIDIS_UUID(String)
More about IS_UUID Function

MASTER_GTID_WAITMASTER_GTID_WAIT()

MASTER_POS_WAITMASTER_POS_WAIT()

NAME_CONSTNAME_CONST(Name, Value)
More about NAME_CONST Function

RELEASE_ALL_LOCKSRELEASE_ALL_LOCKS()

RELEASE_LOCKRELEASE_LOCK()

SYS_GUIDSYS_GUID()
More about SYS_GUID Function

UUIDUUID()
More about UUID Function

UUID_SHORTUUID_SHORT()
More about UUID_SHORT Function

UUID_TO_BINUUID_TO_BIN(String [, Swap])
More about UUID_TO_BIN Function

Numeric functionsString functionsRegular ExpressionsDate and Time functions
Comparison functionsEncryption & CompressionConversion functionsNULL functions
Aggregate functionsWindow functionsJSON functionsGeometric functions
Sequence functionsInformation functionsDynamic ColumnsMiscellaneous functions
More information about the INET6_NTOA SQL function: mysql.com and mariadb.com
Updated: 2023-09-17ImprintContactTerms & conditionsPrivacy & CookiesUpdatesSitemapFacebookLinkedinTwitterStatistics©2020-2024 Heino Cunze-Fischer