Thank you for your feedback.
Form temporarily unavailable. Please try again or contact to submit your comments.

IP address field type

Log in to subscribe to topics and get notified when content changes.

IP address field type

The IP Address (Validated IPV4, IPV6) [ip_addr] field type stores valid IPv4 and IPv6 addresses.

Support for IPv4 and IPv6

Both dot-decimal and hex notation are supported for IPv4 and IPv6. For IPv6, you can use the double-colon notation to compress zeros. Familiarize yourself with IETF RFC5952 for examples and guidelines on text representation for IPv6 addresses.

The following are examples of valid IP addresses:
  • A standard IPv4 address in dot-decimal notation:

  • A same IPv4 address in hex notation:

    0x0A223314 or 0A223314

    Note: The optional prefix 0x is supported.
  • A standard IPv6 address in dot-decimal notation:


  • The same IPv6 address above using the double-colon in place of zeros:


How IP addresses are stored in the database

The IP address ip_addr field is a Variable Character (VARCHAR) field with a length of 45 characters. The values are always stored in four-digit groupings in doc-decimal notation for both IPv4 or IPv6 addresses regardless of the notation you use when you input values in the field. For example:
  • If you enter an IPv6 IP address in an using double-colons, the value in the database is actually expanded to its full IP address without compression: 1507:f0d0:1002:51::4 is saved in the database as 1507:f0d0:1002:0051:0000:0000:0000:0004
  • If you enter an IPv4 address in hex notation, it is saved in the database as the standard dot-decimal notation: 0x0A223314 is saved as

If you run a query on this field type in scripts, make sure to query on the full dot-decimal notation.