MySQL Forums
Forum List  »  Newbie

Re: Mysql_5.6 supports IPv6
Posted by: Rick James
Date: June 20, 2016 12:50AM

Most operators work for BINARY, just as they work for CHAR.

So, once you have stored the IPv6 value in a BINARY(16) column, you can use "<", etc, for checking for overlap.

VARBINARY would also work, but since IPv6 is fixed at 128 bits, "VAR" is not needed.

Options: ReplyQuote


Subject
Written By
Posted
Re: Mysql_5.6 supports IPv6
June 20, 2016 12:50AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.