missing column sizes in information_schemas documentation - Ken Resander - com.mysql.lists.win32

1 message in com.mysql.lists.win32missing column sizes in information_s...

From	Sent On	Attachments
Ken Resander	15 Dec 2005 19:09

Subject:	missing column sizes in information_schemas documentation
From:	Ken Resander (resa...@speed.info.com.ph)
Date:	12/15/2005 07:09:19 PM
List:	com.mysql.lists.win32

There are no maximum column sizes in the MySQL documentation of
INFORMATION_SCHEMAS.

In most cases this is not a problem, as I can guess what a maximum column size
might be, or find out by experimenting via the command line.

The problem is with potentially large columns, such as routine_definition
(in....routines), view_definition (in ... views) and conditions and bodies of
triggers. Unfortunately, these max sizes appear to be implementation-dependent, for
example maxsize of routine_definition is 4000 for SQL Server and 400 for Mimer
SQL.

What are these max column sizes for MySQL?