Skip to content

IPV6

The IPV6 data type stores 16-byte IP addresses in the standard format:

y:y:y:y:y:y:y:y

where each y segment contains any hexadecimal value between 0 and FFFF. Uppercase or lowercase letters are accepted. The eight segments are separated by colons. For example:

684D:1111:222:3333:4444:5555:6:77
2001:db8:3333:4444:cccc:dddd:eeee:ffff
0:0:aaaa:bbbb:ffff:1:1:0

See also IPV4, which is a separate data type, and Network Address Functions. Some network address functions accept netmask values for processing; however, only single-host specifications are stored in IPV6 columns, assuming a /128 netmask.

To explicitly identify a string as an IPV6 literal value, use the IPV6 keyword. For example:

where ip_address > ipv6 '0:0:aaaa:bbbb:ffff:1:1:0'

IPV6 columns accept empty strings.

Parent topic:SQL Data Types