MariaDB [test]> create table tin (addr inet6);

Query OK, 0 rows affected (0.354 sec)

MariaDB [test]> insert into tin (addr) values ('2a00:1a40:0:119:ed51:8d3:1821:7cd5');

Query OK, 1 row affected (0.072 sec)

MariaDB [test]> insert into tin (addr) values ('2a00:1a40:0:0:ed51:8d3:1821:7cd5');

Query OK, 1 row affected (0.037 sec)

MariaDB [test]> select * from tin;

+-----------------------------------+

| addr                              |

+-----------------------------------+

| 2a00:1a40::119:ed51:8d3:1821:7cd5 |

| 2a00:1a40::ed51:8d3:1821:7cd5     |

+-----------------------------------+

2 rows in set (0.001 sec)