>>>>> "BM" == Bruce Momjian <pgman@candle.pha.pa.us> writes:
BM> <P>CHAR() is best when storing strings that are usually the
BM> same length. VARCHAR() is best when storing variable-length strings,
BM> but you want to limit how long a string can be. TEXT is for strings
BM> of unlimited length, maximum 1 gigabyte. BYTEA is for storing
BM> binary data, particularly values that include NULL bytes.</P>
Could you add the length limitation for TEXT to the reference manual?
I searched high and low for that limit, but never found it. Also,
what's the max VARCHAR() or CHAR() I can create? Is that also 1Gb?
Thanks.
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D. Khera Communications, Inc.
Internet: khera@kciLink.com Rockville, MD +1-240-453-8497
AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/