MySQL Forums :: Newbie :: What data type should I use and what storage engine?


Advanced Search

What data type should I use and what storage engine?
Posted by: Randell Benavidez ()
Date: March 29, 2009 10:18AM

I want to store IP addresses in a table in a database. What's the optimal design for searching if a given IP address already exists? Would char/varchar (with the dots between bytes) containing the complete ip address be enough? Or use should I separate the bytes in columns and assign those columns as indeces for the table? And this case only applies for IPv4. How should it be designed for IPv6?

And for that matter, which storage engine should I use?

Options: ReplyQuote


Subject Written By Posted
What data type should I use and what storage engine? Randell Benavidez 03/29/2009 10:18AM
Re: What data type should I use and what storage engine? Rick James 03/30/2009 07:27PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.