3.3 - Text Custom Fields

Am I right in thinking that the “Fill in one text area” CF in RT3.3 holds
no more than 255 characters? Any way to have a text CF of unlimited length?

Thanks,
Steve

Stephen Turner
Senior Programmer/Analyst - Client Support Services
Information Services and Technology (IS&T)

sturner@mit.edu

I think you a wrong. For mysql:

mysql> describe ObjectCustomFieldValues;
| Field | Type | Null | Key | Default | Extra |
| id | int(11) | | PRI | NULL | auto_increment |
| ObjectId | int(11) | | | 0 | |
| CustomField | int(11) | | MUL | 0 | |
| Content | varchar(255) | YES | MUL | NULL | |
| Creator | int(11) | | | 0 | |
| Created | datetime | YES | | NULL | |
| LastUpdatedBy | int(11) | | | 0 | |
| LastUpdated | datetime | YES | | NULL | |
| ObjectType | varchar(255) | | | | |
| LargeContent | longtext | YES | | NULL | |
| ContentType | varchar(80) | YES | | NULL | |
| ContentEncoding | varchar(80) | YES | | NULL | |
| SortOrder | int(11) | | | 0 | |
| Disabled | smallint(6) | | | 0 | |
14 rows in set (0.02 sec)

http://dev.mysql.com/doc/mysql/en/BLOB.html

http://dev.mysql.com/doc/mysql/en/Storage_requirements.html

Looks like you can have 2^32 characters.

-ToddOn Tue, Dec 07, 2004 at 04:31:27PM -0500, Stephen Turner wrote:

Am I right in thinking that the “Fill in one text area” CF in RT3.3 holds
no more than 255 characters? Any way to have a text CF of unlimited length?

Thanks,
Steve

Stephen Turner
Senior Programmer/Analyst - Client Support Services
Information Services and Technology (IS&T)

sturner@mit.edu


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Be sure to check out the RT wiki at http://wiki.bestpractical.com