What's the difference between varchar and varchar2 datatypes in Oracle?

by Biplob
(Dhaka, bangladesh)

What's the difference between varchar and varchar2 datatypes?

Comments for What's the difference between varchar and varchar2 datatypes in Oracle?

Average Rating starstarstarstarstar

Click here to add your own comments

Feb 24, 2015
Rating
starstarstarstarstar
Oracle character datatypes
by: Anonymous

Varchar and varchar2 are both variable length character datatypes supported in Oracle databases. Varchar2 is an Oracle built-in datatype and Varchar is an ANSI datatype.

The main difference between them is that Oracle states that the VARCHAR datatype will change in the future so only the VARCHAR2 datatypes should be used unless you're planning on moving to anotehr database vendor.

The Oracle SQL Language Reference http://docs.oracle.com/database/121/SQLRF/sql_elements001.htm#SQLRF0021 has details on the various data types supported by Oracle.

Click here to add your own comments

Join in and write your own page! It's easy to do. How? Simply click here to return to Oracle Questions.