Hi, I am currently working on a banlist and I am thinking about which data type to choose for storing the IP address in the database. Will the Binary data type be ideal?
martin_57 0 Newbie Poster
rproffitt 2,662 "Nothing to see here." Moderator
I'm reading https://www.daniweb.com/programming/databases/threads/510152/the-best-way-to-store-ipv4-ipv6 which also reveals the INET6_ATON and maybe the other function you'll be asking about very soon.
Dani 4,329 The Queen of DaniWeb Administrator Featured Poster Premium Member
Currently I store IP addresses as Varchar.
Binary is meant for binary data such as images, executables, etc. Not text.
jwenting 1,889 duckman Team Colleague
Store them as strings. Unless you want to do the string to numeric conversion every time that turns the familiar string representation into its numerical format that's the way to go.
But beware that an ip address isn't the best way to go. Not only is it very easy to get a new one, it's also quite likely that multiple people have the same ip address (for example internet cafes, student dorms, etc.).
MAC address is far better, and if you're having paid accounts, username...
Vikas_30 0 Newbie Poster
varchar is easier to use, so I will suggest to use it for storing IP address.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.