Re: CHAR or VARCHAR

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'.
        Karel

-- Karel Zak  <zakkr@zf.jcu.cz>http://home.zf.jcu.cz/~zakkr/C, PostgreSQL, PHP, WWW, http://docs.linux.cz,
http://mape.jcu.cz