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/[EMAIL PROTECTED] > > > -- 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 To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
