Top Architect
Sep 19, 2021 · Databases
Why Store IPv4 Addresses as UNSIGNED INT in MySQL Instead of VARCHAR
The article explains that using a 32‑bit UNSIGNED INT to store IPv4 addresses in MySQL saves space, improves index and range‑query performance, and provides built‑in conversion functions, while also noting readability drawbacks and offering Java utilities for manual conversion.
INET_ATONIP address storageJava
0 likes · 6 min read