How should I convert IP2 to converted IP in MySQL?

Question

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

+4

soren.qvist Apr 30 '11 at 13:36

2 answers

Using INT is fine when you are dealing with IPv4 addresses. However, 128-bit IPv6 cannot be saved as INT or even BIGINT .

+4

Crozin Apr 30 '11 at 13:44

Thiefmaster · Accepted Answer · 2011-04-30T13:39:07+0000

Just use unsigned INT for it.