You are here: Storing IP in MySQL as DOUBLE or INT ? « All PHP « IT news, forums, messages
Storing IP in MySQL as DOUBLE or INT ?

Posted by Pete on 02/02/06 19:44

I'm using an ip-to-country database (http://ip-to-country.webhosting.info)
to look up top level domains for my website visitors. I found a script that
imports the ip ranges into MySQL with the data type "double". The IP is in
something called a "inet_aton" format, and the highest number I can find in
the database is 4294967295, but I'm not sure if a higher number can show up
with the next update of the ip-to-country database.

I was wondering if I have to use "double" for the ip range fields, or if I
can use another data type to make my database smaller?

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация