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

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

Steve06 posted 4 years ago in General
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
ansgar posted 4 years ago
Done in r3746
Steve06 posted 4 years ago
great, does it also allow for longer column comments? if yes, the change log should say so.
ansgar posted 4 years ago
Column comments are not restricted at all - guess you just assumed they are did you?
Steve06 posted 4 years ago
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). "
ansgar posted 4 years ago
So, I should restrict that length in Heidi already? I think some things don't need to be checked twice (Heidi + Server).
Steve06 posted 4 years ago
I agree, unrestricted is fine.

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