Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: VARCHAR/VARCHAR2
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.orgReceived on Sun May 07 2006 - 11:08:46 CDT