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.

Thanks
Ganesh
--
View this message in context: http://www.nabble.com/Limiting-the-t...html#a13213842
Sent from the MySQL - General mailing list archive at Nabble.com.

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

Thank you, Sebastian. Also does the usage of UTF-8 over Latin1 restraints the
usage or extensibility?


Sebastian Mendel wrote:
>
> 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
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=lists@nabble.com
>
>
>

--
View this message in context: http://www.nabble.com/Limiting-the-t...html#a13273514
Sent from the MySQL - General mailing list archive at Nabble.com.