1
CREATE TABLE t1 (a IPV6);
6
) ENGINE=InnoDB COLLATE = utf8_general_ci
7
INSERT INTO t1 VALUES ("fe8::b3ff:fe1a:8329");
8
INSERT INTO t1 VALUES ("::1");
9
INSERT INTO t1 VALUES ("::192.168.100.10");
10
INSERT INTO t1 VALUES ("2001:db8:85a3::8a2e:370:7334");
13
0fe8:0000:0000:0000:0000:b3ff:fe1a:8329
14
0000:0000:0000:0000:0000:0000:0000:0001
15
000:000:000:000:000:000:192.168.100.010
16
2001:0db8:85a3:0000:0000:8a2e:0370:7334
17
SELECT a FROM t1 ORDER BY a;
19
0000:0000:0000:0000:0000:0000:0000:0001
20
000:000:000:000:000:000:192.168.100.010
21
2001:0db8:85a3:0000:0000:8a2e:0370:7334
22
0fe8:0000:0000:0000:0000:b3ff:fe1a:8329