asked on

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

ASKER CERTIFIED SOLUTION

cyberkiwi

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

cyberkiwi

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Victor Kimura

ASKER

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

SOLUTION

cyberkiwi

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Victor Kimura

ASKER

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.