Re: [development] Form field maxlengths vs. database field sizes

2006/2/13, Larry Garfield <larry@garfieldtech.com>:

The real problem is the low character limit on varchar in MySQL, which I believe is 255. (Contrast to MS SQL which is some 8 KB for an nvarchar.)

True. But MySQL is SQL standart compliant where VARCHAR should hold 255 characters max.. For more, BLOB like (often called TEXT when they only have to deal with charactars) fields must be used..