You don't need a bigint, integers in MySQL are 4 bytes just like an IP.
You'd want to use an unsigned integer of course.
---
tani hosokawa
river styx internet
On Wed, 12 May 1999, Dr Eberhard W Lisse wrote:
> In message <Pine.OSF.4.05.9905121712020.11975-100000@stripped>, Alvin
>
> Starr writes:
> > On Wed, 12 May 1999, Matthias Pigulla wrote:
> >
> > > Hi folks,
> > >
> > > I want to pack IP addresses for I have to store a lot of them in a
> > > database ;-)
> >
> > It occures to me that an IP address would be a really usefull datatype.
> > Even possibly an IPV6 type would be handy.
>
> Alvin, Matthias,
>
> If I am not mistaken IP addresses are numbers, expressed for human
> consumption in the dotted quad notation 0.0.0.0 to 255.255.255.255
> which I suspect would lend itself to a calculation and saving the
> resulting number in the BIGINT type, perhaps?
>
> greetings, el
>
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail mysql-thread3298@stripped
>
> To unsubscribe, send a message to the address shown in the
> List-Unsubscribe header of this message. If you cannot see it,
> e-mail mysql-unsubscribe@stripped instead.
>
