missing column sizes in information_schemas documentation

------=_NextPart_000_0025_01C60231.36454440
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

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?

Best regards
Ken Resander


------=_NextPart_000_0025_01C60231.36454440--