How should ip2long converted IP's be stored in MySQL?

Question

I don't know enough about the function, or ip's, to determine how my column structure should be for storing this. Any suggestions?

IPv4 is a 4 byte address, so that fits perfectly into an unsigned INT. (That's what `long` in `ip2long` is.) IPv6 addresses won't fit in 4 bytes though =) You'll need 16 bytes. — Rudie, Apr 30 '11 at 13:47

score 5 · Accepted Answer · answered Apr 30 '11 at 13:39

5

Simply use an unsigned INT field for it.

Also see http://lists.mysql.com/cluster/2781 for a discussion about it.

answered Apr 30 '11 at 13:39

ThiefMaster

score 4 · Answer 2 · edited May 23 '17 at 10:24

4

Using INT is fine when you're dealing with IPv4 addresses. However 128-bits long IPv6 can't be stored as INT or even BIGINT.

edited May 23 '17 at 10:24

Community

answered Apr 30 '11 at 13:44

Crozin

2 Answers2