No support for table comments of up to 2048 chars with MySQL 5.5?
| User, date | Message |
|---|---|
|
Written by Steve06
2 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
2 years ago 4026 posts since Fri, 07 Apr 06 |
Done in r3746 |
|
Written by Steve06
2 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
2 years ago 4026 posts since Fri, 07 Apr 06 |
Column comments are not restricted at all - guess you just assumed they are did you? |
|
Written by Steve06
2 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
2 years ago 4026 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
2 years ago 21 posts since Sun, 27 Mar 11 |
I agree, unrestricted is fine. |
|
Please login to leave a reply, or register at first. |