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?
 
cyberkiwiConnect With a Mentor Commented:
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
 
cyberkiwiConnect With a Mentor Commented:
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
 
cyberkiwiConnect With a Mentor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.