LanceT Posted February 4, 2007 Share Posted February 4, 2007 What are the restrictions of each and what are the benefits (such as how much space can I save with one over the other)? Link to comment https://forums.phpfreaks.com/topic/36984-solved-smallint-vs-mediumint-vs-int/ Share on other sites More sharing options...
shoz Posted February 4, 2007 Share Posted February 4, 2007 http://dev.mysql.com/doc/refman/5.0/en/storage-requirements.html http://dev.mysql.com/doc/refman/5.0/en/data-size.html http://dev.mysql.com/doc/refman/5.0/en/numeric-types.html Link to comment https://forums.phpfreaks.com/topic/36984-solved-smallint-vs-mediumint-vs-int/#findComment-176529 Share on other sites More sharing options...
LanceT Posted February 4, 2007 Author Share Posted February 4, 2007 do u have the link to the diff between text, char, etc ? The mysql site is quite hard to navigate. Sorry for the trouble. Link to comment https://forums.phpfreaks.com/topic/36984-solved-smallint-vs-mediumint-vs-int/#findComment-176538 Share on other sites More sharing options...
shoz Posted February 4, 2007 Share Posted February 4, 2007 This is the table of contents for the manual http://dev.mysql.com/doc/refman/5.0/en/ The subject you're interested in is called "data types". Link to comment https://forums.phpfreaks.com/topic/36984-solved-smallint-vs-mediumint-vs-int/#findComment-176547 Share on other sites More sharing options...
artacus Posted February 4, 2007 Share Posted February 4, 2007 Well that was more informative than the response I was preparing... "You've got to be f'in kidding me! Shoz, can you read it for me and send me an MP3, some of the words are really long." Link to comment https://forums.phpfreaks.com/topic/36984-solved-smallint-vs-mediumint-vs-int/#findComment-176548 Share on other sites More sharing options...
hvle Posted February 4, 2007 Share Posted February 4, 2007 do u have the link to the diff between text, char, etc ? The mysql site is quite hard to navigate. Sorry for the trouble. what you should do is download the entire mysql 5.1 manual into your computer. I recommend the .chm window help format if you are using window cuz it's easy to navigate. This page contains bunch of manual in different format. http://dev.mysql.com/doc/index.html Link to comment https://forums.phpfreaks.com/topic/36984-solved-smallint-vs-mediumint-vs-int/#findComment-176566 Share on other sites More sharing options...
LanceT Posted February 4, 2007 Author Share Posted February 4, 2007 thanks I've figured it out. Never been to the mysql site before. Thanks. Link to comment https://forums.phpfreaks.com/topic/36984-solved-smallint-vs-mediumint-vs-int/#findComment-176568 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.