Ganesh's screen schrieb:
> Is there a way to restrict the length of text field in MySQL. For example, it
> is of 65K limit and could hold more than 20000 characters. Is there a way to
> restrict that to 4000 characters at table/field level. Coz the
> max_allowed_packet constrainted the entire DB.

you can specify the maximum length only on these field types:

CHAR(length)
VARCHAR(length)
BINARY(length)
VARBINARY(length)

--
Sebastian