[rt-users] 3.3 - Text Custom Fields

[Todd Chapman]

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.

-Todd


On 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 at 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