mysql table comment

Hi,

I'm wondering if there is a way to increase the table comment length for mysql. I tried to adjust by phpmyadmin and using dbforge's mysql ide. I wrote about this problem on my site and have some snapshots of the phpmyadmin and dbforge's ide:
http://mysql.tutorialref.com/mysql-table-comment-length-limit.html

Thank you,
vkimura
Victor KimuraSEO, Web DeveloperAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

cyberkiwiCommented:
Hi,

There is no official way to do this.
You can patch the source if you are into open-source and building your own stuff!
http://lists.mysql.com/commits/57746

Otherwise, still no... or wait for v6.0
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
cyberkiwiCommented:
Just to be clear, the commit is also linked from your question, but you can either apply it to your 5.1 source, or wait for it in 6.0
0
Victor KimuraSEO, Web DeveloperAuthor Commented:
Hi cyberkiwi,

1) I perused the commit page and I'm just looking at the first part. I opened the file
include/mysql_com.h

and the commit (from what I understand) is to add this line:
+#define TABLE_COMMENT_INLINE_MAXLEN 180 /* pre 6.0: 60 characters */

before these lines:
 #define TABLE_COMMENT_MAXLEN 2048
 #define COLUMN_COMMENT_MAXLEN 1024
 #define INDEX_COMMENT_MAXLEN 1024

but I can't find this line:
#define TABLE_COMMENT_MAXLEN 2048

2) I can't find this file:
=== modified file 'sql/unireg.cc'

Thanks for your help,
vkimura

=== modified file 'include/mysql_com.h'
--- a/include/mysql_com.h	2008-09-16 08:34:30 +0000
+++ b/include/mysql_com.h	2008-11-04 08:10:49 +0000
@@ -33,6 +33,7 @@
 /*
   Maximum length of comments
 */
+#define TABLE_COMMENT_INLINE_MAXLEN 180 /* pre 6.0: 60 characters */
 #define TABLE_COMMENT_MAXLEN 2048
 #define COLUMN_COMMENT_MAXLEN 1024
 #define INDEX_COMMENT_MAXLEN 1024

Open in new window

0
cyberkiwiCommented:
Have you got a tool like TortoiseSVN? That will take the Patch file and apply it directly...
However, it could be that the source does not patch your version of MySql.

I'm sorry but although I do code, I have never touched mysql codebase so I won't even attempt to pretend I know how to build it.  I guess I thought the question was a general one rather than actually hacking the commit into mysql!
0
Victor KimuraSEO, Web DeveloperAuthor Commented:
Hi cyberkiwi,

I do have TortoiseSVN and use it but I'm not quite certain how to apply the SVN to the MySQL server code. I've never done this for server code. I'm thinking though I would need to recompile MySQL code. Isn't it written in C?

Yes, it's a general question I guess. I thought you may know. I can create another post for this how-to hack mysql code.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
MySQL Server

From novice to tech pro — start learning today.