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

[expired user #5611]'s profile image [expired user #5611] posted 13 years ago in General Permalink
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
Code modification/commit from ansgar.becker, 13 years ago, revision 6.0.0.3746
Support long table comments on newer servers. http://www.heidisql.com/forum.php?t=8105
ansgar's profile image ansgar posted 13 years ago Permalink
Done in r3746
[expired user #5611]'s profile image [expired user #5611] posted 13 years ago Permalink
great, does it also allow for longer column comments? if yes, the change log should say so.
ansgar's profile image ansgar posted 13 years ago Permalink
Column comments are not restricted at all - guess you just assumed they are did you?
[expired user #5611]'s profile image [expired user #5611] posted 13 years ago Permalink
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's profile image ansgar posted 13 years ago Permalink
So, I should restrict that length in Heidi already? I think some things don't need to be checked twice (Heidi + Server).
[expired user #5611]'s profile image [expired user #5611] posted 13 years ago Permalink
I agree, unrestricted is fine.

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