How to convert IPv6 from binary for storage in MySQL

by

We went for a VARBINARY(16) column instead and use inet_pton() and inet_ntop() to do the conversions:

https://github.com/skion/mysql-udf-ipv6

The functions can be loaded into a running MySQL server and will give you INET6_NTOP and INET6_PTON in SQL, just as the familiar INET_NTOA and INET_ATON functions for IPv4.

Edit: There are compatible functions in MySQL now, just with different names. Only use the above if you are on pre-5.6 MySQL and are looking for a convenient future upgrade path.

More Related Contents:

  1. How to avoid to display this error in PHP?
  2. Disappears \ from db value [closed]
  3. The requested URL was not found on this server.
  4. Query with multiple values in a column
  5. How to create a secure mysql prepared statement in php?
  6. Preserve Line Breaks From TextArea
  7. How can I loop through a MySQL result set more than once using the mysql_* functions?
  8. WAMP Cannot access on local network 403 Forbidden
  9. Doctrine 2 and Many-to-many link table with an extra field
  10. How do I give each registered user their own url using PHP?
  11. Post form and update multiple rows with mysql
  12. MySQL “NOT IN” query 3 tables
  13. How to install pdo driver in php docker image?
  14. Calculating distance between zip codes in PHP
  15. Access denied for user ‘root’@’localhost’ with PHPMyAdmin
  16. MySQL retrieve variable from Stored Procedure in PHP PDO
  17. Warning: mysql_query(): 3 is not a valid MySQL-Link resource
  18. Can’t insert Chinese character into MySQL
  19. Send data from android to server via JSON
  20. Laravel 5.5 Error Base table or view already exists: 1050 Table ‘users’ already exists
  21. Dynamically create PHP object based on string
  22. How to build unlimited level of menu through PHP and mysql
  23. php artisan migrate throwing [PDO Exception] Could not find driver – Using Laravel
  24. Change name of Laravel’s created_at and updated_at
  25. MySQL Stored Procedure vs. complex query
  26. PDO and MySQL Fulltext searches
  27. How to avoid “Using temporary” in many-to-many queries?
  28. Difference between mysql_fetch_array and mysql_fetch_row?
  29. 500 Internal Server Error?
  30. Aggregated query without GROUP BY

Leave a Comment