I'm looking to store Tweets in mySQL. I would only need the message body and am looking for a recommendation as far as type and character length. Varchar or Text, if either of those.. how long? Tweets are limited to 140 characters, but I know there is a series of possible gotchas like re-tweets, @'s and links. Anybody went down this path? What worked for you?
I found this but this relates to the user name and not the message..
I think VARCHAR(255) is best for you. There isn't much reason to make a VARCHAR less than 255 since it is a variable length string it takes the same amount of space to store whether you limit it to 255 or 200. I don't think you have need for a TEXT data type. Side note, just in case: Watch out for injection attacks. Don't trust tweets, haha.