Hi,
MySQL 5.5 supports extra-long table and column comments according to the reference (http://dev.mysql.com/doc/refman/5.5/en/create-table.html)
Column comments may reach up to 1024 bytes and table comments up to 2048 bytes.
However, in HeidiSQL 6.0.0.3745 I do not seem to be able to make such big comment fields. The textbox does not allow for it.
Can you allow for extra-long comments depending on MySQL version?
Thanks,
Steve
No support for table comments of up to 2048 chars with MySQL 5.5?
Code modification/commit
bef2d52
from ansgar.becker,
14 years ago,
revision 6.0.0.3746
Support long table comments on newer servers. http://www.heidisql.com/forum.php?t=8105
ok, i didn't test it, i just assumed that column comment length was restricted in heidi as it was for tables.
In any case, the reference says: "A comment for a column can be specified with the COMMENT option, up to 1024 characters long (255 characters before MySQL 5.5.3). "
In any case, the reference says: "A comment for a column can be specified with the COMMENT option, up to 1024 characters long (255 characters before MySQL 5.5.3). "
Please login to leave a reply, or register at first.