News for hackers. Stuff that matters.
Re:What technical reasons are there to have low maximum pass... by lucaspiller on Sunday March 31, 2013 @05:49AM (#5468224)
I believe in InnoDB the way text and varchar(X) is stored is exactly the same. They both only use as much space as the data they are storing requires. However if you pass a 101 character string to a varchar(100) it will be truncated. I'd guess that is useful in some cases, but in reality you probably want to do the truncation in your application so you have more control over it.
Re:What technical reasons are there to have low maximum pass... by quesera on Sunday March 31, 2013 @07:57AM (#5468434)
Truncation is the failure mode which MySQL describes as a feature.

Don't use MySQL.