Bug #6400 Table comment truncated to 60 characters
Submitted: 3 Nov 2004 12:03 Modified: 18 Sep 2007 15:56
Reporter: Neculai Macarie Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: MyISAM storage engine Severity:S4 (Feature request)
Version:4.0.21, 5.0.x OS:Linux (Linux)
Assigned to: CPU Architecture:Any

[3 Nov 2004 12:03] Neculai Macarie
Description:
A table comment cannot contain more then 60 chracters. This is only enough for a very short description.

How to repeat:
alter table table_name comment = "aaa*(60 times)bbb".

Suggested fix:
The comment field should be bigger (at least 255 characters).
[18 Sep 2007 15:56] Valeriy Kravchuk
Thank you for a reasonable feature request. Table comments should be as long as column comments, 255 characters. Just for consistency.