Bruce Momjian writes:
> TEXT limit is 1GB, as shown on the 'limits' FAQ item. Is it worth
> mentioning here? CHAR()/VARCHAR() also 1GB limit.
It is already mentioned there.
--
Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter
---(end of broadc
I want to store a long article in the Postgresql in Linux, how can I put the
content into it and withdraw it back to show? urgent. Thanks.
I use JSP.
I note that all database systems are very dull in BLOB, but we need it to
make a good system. At least, the documentation/faq should have much on it
Perhaps 'limits' should be part of FAQ, not separate entity?
Also a reference (or link) to 'limits' from other sections such as
mentioned below may be more appropriate than duplicating the information.
Frank
At 08:56 AM 10/16/01 -0400, you wrote:
>> > "BM" == Bruce Momjian <[EMAIL PROTECTED
There is a limits FAQ item, not a separate limits FAQ. Sorry for the
confusion.
> Perhaps 'limits' should be part of FAQ, not separate entity?
>
> Also a reference (or link) to 'limits' from other sections such as
> mentioned below may be more appropriate than duplicating the information.
>
>
> "BM" == Bruce Momjian <[EMAIL PROTECTED]> writes:
>> 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?
BM> TEXT limit is 1GB, as
> > "BM" == Bruce Momjian <[EMAIL PROTECTED]> writes:
>
> BM> 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> o
> On Wed, 10 Oct 2001, Aasmund Midttun Godal wrote:
>
> > I am sure this question has been answered in some form or another
> > before, but I can't really find anything on exactly this issue.
> >
> > Are there any differences between varchar and text other than
> >
> > 1. varchar has limited si
On Wed, 10 Oct 2001, Aasmund Midttun Godal wrote:
> I am sure this question has been answered in some form or another
> before, but I can't really find anything on exactly this issue.
>
> Are there any differences between varchar and text other than
>
> 1. varchar has limited size
> 2. varchar
I am sure this question has been answered in some form or another before, but I can't
really find anything on exactly this issue.
Are there any differences between varchar and text other than
1. varchar has limited size
2. varchar is SQL 92 text is not?
Especially regarding performance.
Or am
