Why Store IPv4 Addresses as UNSIGNED INT in MySQL: Benefits, Drawbacks, and Conversion Methods
The article explains that storing IPv4 addresses as a 32‑bit UNSIGNED INT in MySQL reduces storage and index size, speeds up range queries, and provides built‑in conversion functions, while also noting readability drawbacks and offering Java conversion examples.