[rt-devel] RT 2.0.14-pre1
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