Bug #15127 Possibility to store IPv6 addresses
Submitted: 22 Nov 2005 9:28 Modified: 8 Apr 2011 8:33
Reporter: Sebastian Nohn Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: General Severity:S4 (Feature request)
Version:- OS:Any (-)
Assigned to: CPU Architecture:Any

[22 Nov 2005 9:28] Sebastian Nohn 
Description:
It would be great, if MySQL could store IPv6 in a somehow native format.

An IPv6 address is 128 Bit long. That's twice as big as a MySQL "BIGINT" datatype. 

Also the MySQL built-in functions INET_NTOA (Number-TO-Address) and INET_ATON (Address-TO-Number) do not work with IPv6.

How to repeat:
.
[2 May 2007 6:49] Roberto Spadim 
if mysql could work with something like PHP bcmath functions could be very good too, we could allow very big precision without problem of native implementation, ok we will have poor performace but we have a workaround to work with big numbers
[25 Oct 2007 21:47] Morgan Christiansson 
This is a duplicate or related to bug #3318
[28 Nov 2009 14:26] Valeriy Kravchuk 
Request for data type(s) to store IPV6 addresses is still valid. We have WL#2037 for that, but it is still not public and not completed, as far as I can see.
[8 Apr 2011 8:33] Alexander Nozdrin 
This is a duplicate of Bug#34037 (ipv6-capable
inet_aton and inet_ntoa functions).