MySQL: Is it possible to increase the length of a table comment?

Question

I read MySQL comment length questions in StackOverflow here:

• MySQL comment length in MySQL
• How to increase the length of comments in mysql?

The first link suggests that this can be done, and the second suggests that it cannot.

I don’t know why there is such a restriction, since the comments are very useful. Imagine if there was a 60 character limit for your programs.

I wrote about this on my website and got some snapshots for the phpMyAdmin and Dbforge IDE files: http://mysql.tutorialref.com/mysql-table-comment-length-limit.html

Is there a way to change this in phpMyAdmin or maybe even on the CLI?

There is an error report in this task with an error (follow the first StackOverflow link). It seems that the length problem is fixed.

I have MySQL 5.1.42.

Answer 1

No, he cannot, in the question you refer to, have a patch for version 6.0 , which increases it to 2048 characters.
But this is only for 6.0 and only if you compile your own source.