How to store IPv6-compatible address in a relational database

by

I’m not sure which is the right answer for MySQL given that it doesn’t yet support IPv6 address formats natively (although whilst “WL#798: MySQL IPv6 support” suggests that it was going to be in MySQL v6.0, current documentation doesn’t back that up).

However of those you’ve proposed I’d suggest going for 2 * BIGINT, but make sure they’re UNSIGNED. There’s a sort of a natural split at the /64 address boundary in IPv6 (since a /64 is the smallest netblock size) which would align nicely with that.

More Related Contents:

  1. Compare two MySQL databases [closed]
  2. MySQL – Trigger for updating same table after insert
  3. Storing image in database directly or as base64 data?
  4. Implementation of Levenshtein distance for mysql/fuzzy search?
  5. Is MySQL breaking the standard by allowing selecting columns that are not part of the group by clause?
  6. How to get the difference in years from two different dates?
  7. Restore table structure from frm and ibd files
  8. How to select from MySQL where Table name is Variable
  9. How to store a datetime in MySQL with timezone info
  10. MySQL utf8mb4, Errors when saving Emojis
  11. How to store unicode in MySQL?
  12. mysql after insert trigger which updates another table’s column
  13. Error Code: 1406. Data too long for column – MySQL
  14. Search for string within text column in MySQL
  15. How to export a mysql database using Command Prompt?
  16. Mysql database sync between two databases
  17. How to pass parameters to mysql query callback in nodejs
  18. Clear MySQL query cache without restarting server
  19. Checking a table for time overlap?
  20. Does mysql have the equivalent of Oracle’s “analytic functions”?
  21. MySQL Error: Incorrect usage of UPDATE and LIMIT
  22. Mysql insert into 2 tables
  23. MySQL: How to retrieve a random row or multiple random rows?
  24. group by range in mysql
  25. MySQL GROUP BY age range including null ranges
  26. MySQL update statement to store ranking positions
  27. Display all tables. Describe-like functionality
  28. Best tool for synchronizing MySQL databases [closed]
  29. Failed building wheel for mysql-python
  30. How to convert a varchar column type to date type without losing the dates

Leave a Comment