distal-attribute
distal-attribute
distal-attribute
distal-attribute

No support for table comments of up to 2048 chars with MySQL 5.5?

User, date Message
Written by Steve06
3 years ago
Category: General
21 posts since Sun, 27 Mar 11
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
Written by ansgar
3 years ago
4793 posts since Fri, 07 Apr 06
Done in r3746
Written by Steve06
3 years ago
21 posts since Sun, 27 Mar 11
great, does it also allow for longer column comments? if yes, the change log should say so.
Written by ansgar
3 years ago
4793 posts since Fri, 07 Apr 06
Column comments are not restricted at all - guess you just assumed they are did you?
Written by Steve06
3 years ago
21 posts since Sun, 27 Mar 11
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). "
Written by ansgar
3 years ago
4793 posts since Fri, 07 Apr 06
So, I should restrict that length in Heidi already? I think some things don't need to be checked twice (Heidi + Server).
Written by Steve06
3 years ago
21 posts since Sun, 27 Mar 11
I agree, unrestricted is fine.
 

Please login to leave a reply, or register at first.