Feature #7007: MySQL Field size for large text fields - Redmine

Actions

Copy link

Feature #7007

closed

MySQL Field size for large text fields

Added by Nathan Rijksen almost 14 years ago. Updated about 9 years ago.

Status:

Closed

Priority:

Normal

Assignee:

Category:

Database

Target version:

Start date:

2010-11-30

Due date:

% Done:

Estimated time:

Resolution:

Duplicate

Description

I noticed that the database design for redmine used TEXT type for multiple fields that can contain large amounts of data, particularly the "description" field in the "issues" table and the "notes" field in the "journals" table. These fields in my opinion should really be given the MEDIUMTEXT type as reporters / commenters can often paste in large amounts of data (such as logs). that will easily exceed the size limit of 64kb which TEXT imposes.

I know that the sensible thing to do here would be for the person to simply add these logs as an attachment but you can not always expect people to be sensible, especially if you work with people that are not very technical and are simply reporting some bugs to you in a way you explained them to (which, as you might have guessed, is what we do at my work).

I've personally already updated my DB to use MEDIUMTEXT but I thought I'd report it here as I think it's in the interest of redmine to have it on that by default.

Related issues