如何在关系数据库中存储与IPv6兼容的地址

CREATE TABLE ipv6_addresses (
  id INT NOT NULL AUTO_INCREMENT,
  address VARBINARY(16) NOT NULL,
  PRIMARY KEY (id)
);

INSERT INTO ipv6_addresses (address) VALUES (INET6_ATON('2001:0db8:85a3:0000:0000:8a2e:0370:7334'));

SELECT INET6_NTOA(address) FROM ipv6_addresses;

CREATE TABLE ipv6_addresses (
  id SERIAL PRIMARY KEY,
  address BYTEA NOT NULL
);

INSERT INTO ipv6_addresses (address) VALUES (to_ipv6('2001:0db8:85a3:0000:0000:8a2e:0370:7334'));

SELECT to_char(address, 'ipv6') FROM ipv6_addresses;

CREATE TABLE ipv6_addresses (
  id INT IDENTITY(1,1) PRIMARY KEY,
  address VARBINARY(16) NOT NULL
);

INSERT INTO ipv6_addresses (address) VALUES (CONVERT(VARBINARY(16), '2001:0db8:85a3:0000:0000:8a2e:0370:7334'));

SELECT CONVERT(VARCHAR(39), address) FROM ipv6_addresses;