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: DA Morgan <damorgan_at_psoug.org>
Date: Sun, 07 May 2006 09:08:46 -0700
Message-ID: <1147018132.33161@bubbleator.drizzle.com>


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
Received on Sun May 07 2006 - 11:08:46 CDT

Original text of this message

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