For example, this field I am writing in now can holds a lot of text. I'm assuming this is a mySQL VARCHAR or TEXT field but this is just a guess. According to MySQL: Large VARCHAR vs. TEXT? TEXT should be used. Where is the line for switching from VARHCAR to TEXT. I'm looking for something more concrete then the link I posted.
I of course want to be able to search开发者_高级运维 the text and edit it.
VARCHAR is limited to 255 characters in all mysql versions <= 5.0.3
There are various sizes of TEXT fields as well, TEXT, MEDIUMTEXT, LONGTEXT.
You can find more details here: http://dev.mysql.com/doc/refman/5.5/en/blob.html
I would strongly suggest defaulting to text or larger for what you're proposing.
精彩评论