There are few common (I’m not talking about all o them, just frequently used) types of data storage in MySQL – texts for texts, integers for integers and blobs for binary data.
So of course, you can always use the largest available, but speaking in terms of efficiency, how do you decide which one of them to use? By max size of content stored there.
Text storage types
Varchar = 28-1 = 255 characters max.
Text = 216-1 = 65 535 characters (~64kb) max.
Mediumtext = 224-1 = 16 777 215 characters (~16Mb) max.
Longtext = 232-1 = 4 294 967 295 characters (~4Gb) max
Integer storage types
Tinyint = 28-1 = 255 unsigned or -128 to 127 signed.
Smallint = 216-1 = 65 535 unsigned or -32768 to 32767 signed.
Int = 232-1 = 4 294 967 295 unsigned or -2 147 483 648 to 2 147 483 647 signed
Bigint = 264-1 = 18 446 744 073 709 551 615 unsigned or -9223372036854775808 to 9223372036854775807signed
Data storage types
Blob = 216 = 65 536 bytes (~64kb) max.
Mediumblob = 224 = 16 777 216 bytes (~16Mb) max.
Longblob = 232 = 4 294 967 296 bytes (~4Gb) max
Use wisely.
That’s a great post. Thank you so much.
Congratulations for posting such a useful blog. Your blog isn’t only informative but also extremely artistic too. There usually are extremely couple of individuals who can write not so easy articles that creatively. Keep up the good writing !!
That’s what i call “great post”. Thank you so much.
Excellent post, mate! Thanks for the useful information
An interesting discussion is value comment. I feel that it is best to write more on this subject, it might not be a taboo topic but usually individuals are not sufficient to speak on such topics. To the next. Cheers
You can find various agencies which deals with evidences located at a crime scene. Police use it for investigation, prosecuting attorney presents it before court of law as effectively as a forensic science technician analyzes evidences thoroughly to help other agencies in criminal procedure. A forensic science technician conducts comprehensive chemical and physical study of evidence submitted by a law enforcement agency
That’s what i call “great post”. Thank you so much.
definitely like your internet web site but you need to check the spelling on several of your posts. Several of them are rife with spelling troubles and I find it extremely troublesome to tell the truth nevertheless I will certainly come back again.
That’s what i call “great post”. Thank you so much.
The http://edgars.cellfex.org/2010/04/01/how-to-select-correct-text-storage-data-type-in-mysql/ is definitely the freshest with this treasured topic. I concur together along with your conclusions and might eagerly look forward to your future updates. Saying thanks received’t purely be passable, for the good lucidity on your writing. fotografia ślubna
Excellent post, mate! Thanks for the useful information
Excellent post, mate! Thanks for the useful information
This really is often a great blog, could you be interested in working on an interview about just how you developed it? If so e-mail myself!
That’s what i call “great post”. Thank you so much.
I like this weblog it’s a master piece! Glad I found this on google.
That’s what i call “great post”. Thank you so much.
Im no expert, but I consider you just crafted the best point. You naturally comprehend what youre speaking about, and I can definitely get behind that. Thanks for staying so upfront and so truthful.
Chaga mushroom tea appears to be shown a fantastic deal of mankind by means of Ruskies artice writer Alexandr Solzhenitsyn utilizing your partner’s new ‘Cancer Ward’ the spot predominant reputation has been curable of pisces with the support of the assist of this relaxer. Chaga
I cherished up to you’ll receive carried out right here. The sketch is tasteful, your authored material stylish. nonetheless, you command get got an shakiness over which you would like be turning in the following. sick unquestionably come much more formerly once far more since exactly exactly the same just about a great deal regularly within case you defend this hike.
Excellent post, mate! Thanks for the useful information
That’s what i call “great post”. Thank you so much.
Did anyone else have an issue viewing this page in opera? I kinda did. Although the info is great, thabnks again man.
That’s a great post. Thank you so much.
When I initially commented I clicked the -Notify me when new comments are added- checkbox and now each time a remark is added I get four emails with exactly the same comment. Is there any manner you possibly can take away me from that service? Thanks!
Excellent post, mate! Thanks for the useful information
Excellent post, mate! Thanks for the useful information
After study several of the blog posts on your personal internet internet site now, and i genuinely much like your means of blogging. I bookmarked it to my bookmark internet web site list and are checking back soon. Pls look at my internet site as properly and let me know what you think.
That’s what i call “great post”. Thank you so much.
Nice post. I learn something new and challenging on blogs I stumbleupon everyday. It’s always helpful to read content from other authors and practice a little something from their web sites.
Excellent post. I learned a lot reading it. Thanks.
you have a great sites right here! would you like to make a number of invite posts on my blog?
A useful discussion merits comment. I think that you should create more on this issue, it’d not really become a taboo question however generally people are not enough to chat on this sort of issues. To the next. Cheers
I’m typically to running a blog and i really admire your content. The article has really peaks my interest. I’m going to bookmark your web site and preserve checking for brand spanking new information.
The subsequent time I read a weblog, I hope that it doesnt disappoint me as a lot as this one. I mean, I know it was my option to read, however I really thought youd have one thing interesting to say. All I hear is a bunch of whining about one thing that you could fix should you werent too busy looking for attention.
It’s difficult to get experienced people on this issue, however, you sound like you know what you’re sharing! Thanks
I wanted to jot down a small message so as to appreciate you for some of the nice points you are giving out here. My incredibly long internet look up has now been rewarded with incredibly good facts to write about with my two friends. I would assert that most of us visitors are unquestionably endowed to dwell in a decent site with so many wonderful people with interesting secrets. I feel very much lucky to have seen your web page and look forward to really more cool times reading here. Thank you again for a lot of things.
you are in point of fact a great webmaster. The web website loading pace is incredible. It seems that you are doing any unique trick. Also, The contents are masterpiece. you’ve done a exceptional job in this topic!
I like this post, enjoyed this one thank you for posting. “To affect the quality of the day that is the art of life.” by Henry David Thoreau.