Are there any reasons for not using the “text” type whenever a variable length string field is needed? Are there penalties in disk usage, memory usage or performance?
What are the differences between declaring something “varchar” or “varchar(n)” or “text”? (I realize that the middle one has an upper limit while the others do not.)
