Jump to content

Using INT or VARCHAR to store numbers, or convert to HEX?


jeremyhowell

Recommended Posts

I need to  save as much space in my database as possible, and I will be storing Facebook IDs in a table, which are very long, and I was wondering whether I would save more space converting the numbers to HEX and storing them in a VARCHAR, or just saving them in an INT field.

 

Thanks.

I dont think that it is really necessary to save them as hex. If you were to convert them to hex it would take extra time to run, then when you needed to query it back you would have to decrypt it (taking extra time) and its not really going to take up that much space in the database. You could however always store them as a varchar if you choose though.

I would store it as an integer just because that is what it is and it generally is a good idea to store data as the type that they are. But there are always exceptions to the rules.

 

A good read that may help you decide:

http://dev.mysql.com/doc/refman/5.0/en/storage-requirements.html

 

Check out that.

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.