Thursday, May 15, 2008

Difference between VARCHAR and VARCHAR2

varchar means fixed length character data(size) ie., min size-1 and max-2000

where as varchar2 means variable length character data ie., min-1 to max-4000



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.

1 comment:

shanmuga said...

first line of the about state ment is wrong.
varchar and varchar2 both are variable lenth.

Post a Comment