Re: Newbie Question: How long can a varchar be?

From: <adolph_mendicant_at_my-deja.com>
Date: Wed, 22 Nov 2000 21:07:42 GMT
Message-ID: <8vhcis$8c8$1@nnrp1.deja.com>

In article <3A1C23DD.E017B00_at_bridgewatersystems.com>, Tony Walby <tony.walby_at_bridgewatersystems.com> wrote:
> Varchar2 can be 4000 characters in length max.

Is Varchar2 standard SQL? I can't use Oracle extensions.

How big is varchar?

>
> adolph_mendicant_at_my-deja.com wrote:
>
> > I'm using 8000 byte varchars on SQLServer, but I get an error from
> > Oracle 8i when I try to create them. The error is "ORA-00910". I
> > can't find anything in the docs that came with the trial CD or on
the
> > Oracle site that mentions the maximum length of a varchar.
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Nov 22 2000 - 15:07:42 CST