IPv6 Address
Type Registry
IPv6 Address
technology.internet.ip_v6 Standard IPv6 address format with 8 16-bit hex groups separated by colons. May use :: notation for zero compression. Resolves to VARCHAR.
Domain technology›internet
Casts to VARCHAR
Scope Universal
Try it
CLI
$ finetype infer -i "2001:0db8:85a3:0000:0000:8a2e:0370:7334"
→ technology.internet.ip_v6 DuckDB
Detect
SELECT finetype('2001:0db8:85a3:0000:0000:8a2e:0370:7334');
-- → 'technology.internet.ip_v6' Cast expression
CAST({col} AS VARCHAR) Safe cast pipeline
-- Normalise and cast in one step
SELECT TRY_CAST(finetype_cast(my_column) AS VARCHAR) AS clean_value
FROM my_table
WHERE finetype(my_column) = 'technology.internet.ip_v6'; JSON Schema
finetype schema technology.internet.ip_v6 {
"$id": "https://noon.sh/schemas/technology.internet.ip_v6",
"$schema": "https://json-schema.org/draft/2020-12/schema",
"description": "Standard IPv6 address format with 8 16-bit hex groups separated by colons. May use :: notation for zero compression. Resolves to VARCHAR.",
"examples": [
"2001: 0db8: 85a3: 0000: 0000: 8a2e: 0370: 7334",
"2001:db8: 85a3:: 8a2e: 370: 7334",
":: 1",
"fe80:: 1"
],
"pattern": "^([0-9a-fA-F]{1,4}:){7}[0-9a-fA-F]{1,4}$",
"title": "IPv6 Address",
"type": "string"
} Examples
2001:0db8:85a3:0000:0000:8a2e:0370:73342001:db8:85a3::8a2e:370:7334::1fe80::1 Also known as
ipv6