[development] Form field maxlengths vs. database field sizes

Gildas Cotomale gildas.cotomale at gmail.com
Mon Feb 13 20:45:33 UTC 2006


2006/2/13, Larry Garfield <larry at 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..


More information about the development mailing list