Max length for client ip address [duplicate]

by

There’s a caveat with the general 39 character IPv6 structure. For IPv4 mapped IPv6 addresses, the string can be longer (than 39 characters). An example to show this:

IPv6 (39 characters) : 

ABCD:ABCD:ABCD:ABCD:ABCD:ABCD:ABCD:ABCD

IPv4-mapped IPv6 (45 characters) : 

ABCD:ABCD:ABCD:ABCD:ABCD:ABCD:192.168.158.190

Note: the last 32-bits (that correspond to IPv4 address) can need up to 15 characters (as IPv4 uses 4 groups of 1 byte and is formatted as 4 decimal numbers in the range 0-255 separated by dots (the . character), so the maximum is DDD.DDD.DDD.DDD).

The correct maximum IPv6 string length, therefore, is 45.

This was actually a quiz question in an IPv6 training I attended. (We all answered 39!)

More Related Contents:

  1. How to implement a many-to-many relationship in PostgreSQL?
  2. How to create multiple one to one’s
  3. What are best practices for multi-language database design? [closed]
  4. Strings as Primary Keys in SQL Database [closed]
  5. Are soft deletes a good idea? [duplicate]
  6. Database Design for Revisions?
  7. A beginner’s guide to SQL database design [closed]
  8. Physical vs. logical (hard vs. soft) delete of database record? [closed]
  9. Storing money in a decimal column – what precision and scale? [closed]
  10. single fixed table with multiple columns vs flexible abstract tables
  11. Primary key or Unique index?
  12. How to design a database for User Defined Fields?
  13. Composite Primary key vs additional “ID” column?
  14. Database EAV Pros/Cons and Alternatives
  15. Name database design notation you prefer and why?
  16. MySQL – how to front pad zip code with “0”?
  17. Use email address as primary key?
  18. Composite Primary Keys : Good or Bad?
  19. SQL ON DELETE CASCADE, Which Way Does the Deletion Occur?
  20. SQL: Using NULL values vs. default values
  21. What does ON [PRIMARY] mean?
  22. What is the best way to implement soft deletion?
  23. Relational Data Model for Double-Entry Accounting
  24. Temporal database design, with a twist (live vs draft rows)
  25. Historical / auditable database
  26. Single or multiple databases
  27. how to create this table in sql server?
  28. Why do you create a View in a database?
  29. Is this a good way to model address information in a relational database?
  30. Executing SQL query on multiple databases

Leave a Comment