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: VARCHAR/VARCHAR2

Re: VARCHAR/VARCHAR2

From: <bbulsara23_at_hotmail.com>
Date: 7 May 2006 09:33:41 -0700
Message-ID: <1147019621.922647.288590@e56g2000cwe.googlegroups.com>


DA Morgan wrote:
> bbulsara23_at_hotmail.com wrote:
> >> DA Morgan wrote:
> >> astalavista wrote:
> >>> Hi,
> >>>
> >>> Just a little question :
> >>> why using VACHAR2 instead of VARCHAR ?
> >>>
> >>> Thanks for lights ...
> >> Primarily becaue VARCHAR does not exist except in C.
> >>
> >> Daniel Morgan
> >> www.psoug.org
> >
> > I don't understand this answer.
> >
> > Barry
>
> VARCHAR is a C language data type. When Oracle was first
> created programming was done in C not PL/SQL and VARCHAR2
> was created as the default database data type for
> variable length character strings.
> --
> Daniel A. Morgan
> University of Washington
> damorgan_at_x.washington.edu
> (replace x with u to respond)
> Puget Sound Oracle Users Group
> www.psoug.org

I see what you are saying Daniel. Note that saying VARCHAR is a C language data type is as valid as saying OCIExtProcContext is a C language data type ;)
Barry Received on Sun May 07 2006 - 11:33:41 CDT

Original text of this message

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