Storing IP Address in Mysql Database

by 6

Storing IP addresses is a common issue when developing web applications. It may be needed for variety of features like banning or resolving user localization. IP address is also used by many applications for improving security system (just try for one time to log into Gmail service from another country and you will be probably prompted with security question).

One of the main and most obvious questions while implementing those features is how to store that kind of data, as far as there is no dedicated IP address data type in MySQL engine.