Article:		SQL Data Types
Subject:		What is the difference between varchar and varchar2 in ORACLE
Date:		2004-06-07 11:17:00
From:		chand_05
What is the exact difference between varchar and varchar2 in ORACLE. If they are same why do we need both unlike in SQL Server

Showing messages 1 through 5 of 5.

• What is the difference between varchar and varchar2 in ORACLE
  2004-11-14 21:48:00  Question&answer [Reply | View]
  
  
  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
  
  
  
• What is the difference between varchar and varchar2 in ORACLE
  2006-09-20 08:22:41  sravan.k [Reply | 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?
  
• What is the difference between varchar and varchar2 in ORACLE
  2006-12-16 01:40:25  Nicomart [Reply | View]
  
  
  varchar is setted is ascii. varchar2 uses unicode.
• What is the difference between varchar and varchar2 in ORACLE
  2006-12-16 01:39:39  Nicomart [Reply | View]
  
  
  *in ascii, sorry
• What is the difference between varchar and varchar2 in ORACLE
  2008-06-02 21:22:31  muzahid [Reply | View]
  
  
  Is this is the only difference ........