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
The rt-users Archives
Be sure to check out the RT wiki at http://wiki.bestpractical.com