rahultripathi

 Profile Answers by rahultripathi 

• Sep 22nd, 2005

 

Both are related to varible length but difference that varchar stores only 2000 byte character of data and varchar2 stores 4000 byte charecter of data . 

If any problem don't hesitate write to rahultripathi@myway.com

Ketan Pathak

• Oct 11th, 2005

 

The other difference is that, varchar occupy total length which is define to create database while the varchar2 occupy the total length of the given string.

Ajay Sharma

• Oct 19th, 2005

 

Both VARCHAR and VARCHAR2 are same. ORACLE may remove VARCHAR in its future version.

dhanunjay valisetty

• Nov 8th, 2005

 

dear friend... here is small clarification w.r.t your answer reg...

The VARCHAR datatype is actually a subtype of VARCHAR2, with the same range of values found in VARCHAR2. VARCHAR, in other words, is currently synonymous with VARCHAR2. Use of VARCHAR offers compatibility with ANSI and IBM relational databases. There is a strong possibility, however, that VARCHAR's meaning might change in a new version of the ANSI SQL standards. Oracle recommends that you avoid using VARCHAR if at all possible, and instead stick with VARCHAR2 to declare variable-length PL/SQL variables (and table columns as well).

cheerz..

dhanunjay

Ketan Pathak Wrote: The other difference is that, varchar occupy total length which is define to create database while the varchar2 occupy the total length of the given string.

helper

• Aug 21st, 2006

 

Varchar and Varchar2 differs only by space.

2000 byes is allocated for varchar and 4000 bytes for varchar2

shravan

• Oct 27th, 2006

 

  If we declare datatype as VARCHAR then it will occupy space for NULL values, In case of VARCHAR2 datatype it will not occupy any space.

kumars77

 Profile Answers by kumars77 

• May 1st, 2008

 

This is not right ans because varchar datatype store more than 2000 character i checked it no error found so plz anbody give right ans

smithanair

 Profile Answers by smithanair 

• Sep 17th, 2008

 

VARCHAR is used to store alphanumeric values without padding unused memory locations. But VARCHAR2 is used to store alphanumeric values with padding unused memory locations. so using VARCHAR2 we are saving memory locations.

cybersavvy

 Profile Answers by cybersavvy 

• Feb 5th, 2009

 

Varchar2 in Oracle is equal to varchar in SQL Server. There is no varchar2 data type in SQL Server