I want to make a small social network. For messaging body which one is more suitable? VARCHAR or TEXT? if VARCHAR how long is efficient?
closed as too broad by Paul White♦, bluefeet♦, RolandoMySQLDBA, Max Vernon, ypercube Oct 3 '13 at 20:10
There are either too many possible answers, or good answers would be too long for this format. Please add details to narrow the answer set or to isolate an issue that can be answered in a few paragraphs. If this question can be reworded to fit the rules in the help center, please edit the question.
To completely determine column type, I might suggest to do following:
You have selection of two types:
"Which of them to use?" depends on subject area and is primarily opinion-based question. If you ask me, then I might suggest to use
For small messages, storage space of which requires less than 255 bytes,
I'm supposing that you use MySQL RDBMS.