Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Newbie Question: How long can a varchar be?

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

From: Brian Tkatch <SPAMBLOCK.Maxwell_Smart_at_ThePentagon.com.SPAMBLOCK>
Date: Thu, 23 Nov 2000 13:49:22 GMT
Message-ID: <3a1d202f.220286468@news.alt.net>

On Wed, 22 Nov 2000 21:07:42 GMT, adolph_mendicant_at_my-deja.com wrote:

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

I believe VARCHAR is standard SQL.

From the docs:

VARCHAR Datatype
The VARCHAR datatype is currently synonymous with the VARCHAR2 datatype. Oracle recommends that you use VARCHAR2 rather than VARCHAR. In the future, VARCHAR might be defined as a separate datatype used for variable-length character strings compared with different comparison semantics.

Brian Received on Thu Nov 23 2000 - 07:49:22 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US