New custom fields proposal

[Sean McAfee]

Whoops, missed something--

Gervase Markham <gerv at mozilla.org> wrote:
>Sean McAfee wrote:
>> Each string field is flagged as belonging to one of two varieties:
>> short and long.  A short string field can hold a maximum of 255
>> characters, and may contain no vertical whitespace characters
>> (carriage return, newline, or vertical tab).  It is represented on
>> Bugzilla's Web interface using a single-line text form element.  A
>> long string field can hold large amounts of text, possibly consisting
>> of several lines.  It is represented on Bugzilla's Web interface as a
>> multiline textarea form element.

>Is there a max size for the long field? I think 32K should be OK.

Why 32K?  A "text" column, which would be the natural choice for a "long,
but not TOO long" string, has a maximum length 64K characters.  Did you have
some other column type in mind, or did you misremember the maximum size of a
"text" column?  Or did you mean to restrict the size for other reasons?


--Sean