From: Ganesh's screen (ramaswamy.ganeshgmail.com)
Date: Thu Oct 18 2007 - 08:31:40 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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=listsnabble.com
>
>
>

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

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]