How to Best Store IPv6 Addresses in MySQL?

Storing IPv6 Addresses in MySQL

MySQL currently lacks specific functions for storing IPv6 addresses. This question addresses the recommended approach for this task.

Recommended Data Type

The recommended data type for storing IPv6 addresses is BINARY(16). This data type effectively represents the 128-bit IPv6 address in binary format.

Function for Inserting IPv6 Addresses

Unfortunately, MySQL does not provide a built-in function for converting textual IPv6 addresses to binary. As a result, you will need to implement this conversion in your application or create a User-Defined Function (UDF) in MySQL to handle this task.

MySQL 5.6.3 and Later

MySQL 5.6.3 introduced support for IPv6 addresses. The data type for storing IPv6 addresses is now VARBINARY(16), and the INET6_ATON(expr) function can be used to convert textual IPv6 addresses to binary.

Pre-MySQL 5.6.3 and MariaDB

For older versions of MySQL and MariaDB, you can use the implementation described in "EXTENDING MYSQL 5 WITH IPV6 FUNCTIONS" to add IPv6 support. This solution provides UDFs for converting between textual and binary IPv6 addresses.

The above is the detailed content of How to Best Store IPv6 Addresses in MySQL?. For more information, please follow other related articles on the PHP Chinese website!