my $sth = $dbh->prepare("INSERT INTO `accounting` (`IPv6_string`, `IPv6_binary`) VALUES (?, ?);"); $sth->bind_param(1, 'fd01:0000:0000:0000:0000:0000:0000:0003'); $sth->bind_param(2, '0xfd010000000000000000000000000003', SQL_VARBINARY); $sth->execute();