Posted by frizzle on 11/18/31 11:40

Jasen Betts wrote:
> On 2006-02-15, frizzle <phpfrizzle@gmail.com> wrote:
> > Hi there,
> >
> > I'm saving ip addresses of blocked visitors into a mySQL DB.
> > The function with wich i retrieve the address is below this message.
> >
> > What i wonder is, if it's ok to remove the dots from the ip address,
> > and only
> > save the numbers into the database. I assume it will be quicker to
> > compare.
> > But i don't know if it could mess up ip addresses. E.g. confuse
> > 12.34.56.78 with 123.45.6.78
>
> if mysql has an IP address datatype like postgresql does use that.
>
>
> --
>
> Bye.
> Jasen

AFAIK it hasn't ...

[Back to original message]