ISSUE :
 
Profile photo
Submitted by ETL Talend
on August 2nd, 2011 at 13:22:03 EST

Differerence between varchar varchar2 and string which one to choose and why?

I see lot of our table column data type is varchar2.
I am not sure why DBA are choosing one over the other?
Thanks,
ETL


Profile photo
Replied by Oracle DBA
on August 3rd, 2011 at 15:09:30 EST
Varchar is fixed length right padded with null and is ANSI standard
Varchar2 is variable length make use of efficient space but Oracle specific
I think you mean Char by string which is fixed length right padded with spaces
Accepted Answer
Accepted
 Answer

Profile photo
Replied by ETL Talend
on August 3rd, 2011 at 15:10:08 EST
Thanks.