Re: CHAR or VARCHAR

On Thu, 22 Mar 2001, Karel Zak wrote:

> On Thu, Mar 22, 2001 at 08:05:19AM -0300, Martin A. Marques wrote:
> > >
> > > In 7.1(currently in beta), long values can be stored
> > > outside that so you have more of a number of columns
> > > limit rather than a per value limit.  Technically,
> > > it's probably still not a great idea to be sticking
> > > megs in there for performance reasons.
> > 
> > I can't believe that there is no limit. You mean that I put this:
> > 
> > VARCHAR(1000000000000000000000000000000000)
> 
>  ...length for type 'varchar' cannot exceed 10485760.
>  
>  But "no limit" means 'text'.

True, but in a practical sense, even 10M or so is probably
pushing your luck unless you've got alot of ram.