Stored procedures comment too short

[Stefano Locati]

Hello,

I've noticed that the stored procedure comment you can add using the COMMENT statement is limited to only 64 chars. That's not enough to describe what a procedure does. Do you think it's safe to change mysql.proc.comment datatype from char(64) to varchar(255) or even text or it's better not?

Further I've seen that mysql (i'm using 5.0.16 now) drops all comments with c-style syntax within your code ( /* */ ), while for instance MS SQL Server keeps them.

I think comments are very important to build a maintenable software. What can I do to improve the present situation?

Thanks,
Stefano
http://software.obliquid.com/