Article:
  SQL Data Types
Subject:   What is the difference between varchar and varchar2 in ORACLE
Date:   2004-11-14 21:48:00
From:   Question&answer
Response to: What is the difference between varchar and varchar2 in ORACLE

The difference between Varchar and Varchar2 is both are variable length but only 2000 bytes of character of data can be store in varchar where as 4000 bytes of character of data can be store in varchar2.


Thanx


Haribrata Nayak



Main Topics Newest First

Showing messages 1 through 1 of 1.

  • What is the difference between varchar and varchar2 in ORACLE
    2006-09-20 08:22:41  sravan.k [View]

    is this the only difference exits between varchar & varchar2?
    if so why Oracle introduced 2 types?
    is there any version that supports only varchar?