[rt-devel] RT 2.0.14-pre1

Florian Weimer Weimer at CERT.Uni-Stuttgart.DE
Mon Jul 1 14:19:10 EDT 2002

Vivek Khera <khera at kcilink.com> writes:

> I think text == varchar(2^24-1) or something about like that.  My
> feeling is that varchar() of a given size is mainly for documenting
> your structure and expected use.  The data storage is not that
> different.  Perhaps you save a byte or two by having smaller length
> counters for shorter varchars, but I don't know.

Some people claim that internally, a TEXT column is represented by an
offset into a different table, but this is not the case, at least if
a row stays below the TOAST limit (somewhere around 8 kilobytes).

Florian Weimer 	                  Weimer at CERT.Uni-Stuttgart.DE
University of Stuttgart           http://CERT.Uni-Stuttgart.DE/people/fw/
RUS-CERT                          fax +49-711-685-5898

More information about the Rt-devel mailing list