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