Mysql table comment increase length. Is this a bug?
- by Victor Kimura
Hi,
I read the mysql table lengths questions on stackoverflow on here:
questions/391323/table-comment-length-in-mysql
questions/2473934/how-to-increase-mysql-table-comments-length
The first link suggests that it can be done and the second suggests it cannot. I don't know why there is this limitation as the comments are very useful. Imagine if there was a limit of 60 characters for your programs.
I wrote about this on my site and have some snapshots to the phpmyadmin and Dbforge MySQL IDEs:
http://mysql.tutorialref.com/mysql-table-comment-length-limit.html
Is there a way to change this in phpmyadmin or perhaps even on the CLI?
There is a bug commit report from MySQL on this particular problem (follow the link from the stackoverflow (first link).
It seems to state that the length problem is fixed. I have MySQL 5.1.42.
Thank you,
Victor