©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_ATON SQL Function in MySQL and MariaDB - Convert IPv6 address to binary

INET6_ATONSyntax:INET6_ATON(String)
Return value:BINARY
Function type:Miscellaneous function
Function Description

The INET6_ATON() function returns a binary string representing the numeric value of the IPv6 address in "String".

If the value of "String" is invalid or NULL, the INET6_ATON() function returns NULL.

SQL Examples for the INET6_ATON function

 1
 2
 3
 4
 5
 6
 7
 8
 9


SELECT hex(INET6_ATON('fe80::8ade:7cff:fef7:e3a5'));
SELECT hex(INET6_ATON('2a02:3030:81e:d48d:cd91:e972:5c6b:90a8'));
SELECT hex(INET6_ATON('::1'));

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

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

In MySQL and MariaDB the INET6_ATON() function is used to convert an IPv6 address from its text representation to a numeric form. The function takes an IPv6 address in its text format as an argument and returns a binary string representing the numeric value of the IPv6 address, suitable for storage in a binary table columns (BINARY, VARBINARY, BLOB) or in comparisons or queries to filter or retrieve specific ranges of IPv6 addresses can be used. By converting IPv6 addresses to their numeric form, calculations or operations can be performed on them, for example to create subnets or extract certain parts of the address.
HOURIFIFNULLINET6_ATONINET6_NTOAINET_ATONINET_NTOA

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_NTOAINET6_NTOA(Binary string)
More about INET6_NTOA 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_ATON SQL function: mysql.com and mariadb.com
Updated: 2023-09-17ImprintContactTerms & conditionsPrivacy & CookiesUpdatesSitemapFacebookLinkedinTwitterStatistics©2020-2024 Heino Cunze-Fischer