Difference between varchar and varchar2?
Answered by: muralidhar_batta
View all answers by muralidhar_batta
Member Since Feb-2006 | Answered On : Feb 26th, 2006
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
Varchar & Varchar2 both having the same size, & working as same. Bt the main diff is varchar is an ANSI Datatype & Varchar2 is the Oracle datatype.
Varchar - If we declare datatype as varchar then it will occupy space for null values. It can store upto 2000 bytes of character. Varchar2 - If we declare datatype as varchar2, it will not occupy any space. It can store 4000 bytes of character. Thanx,
Engineering
Interview Coaching
Interview Questions
Tech FAQs
Describe a time when you had to work under pressure.
Tell me three things about you, which are not found in your resume
How do you handle difficult situations?
What do you think about continuous learning?
What are the career opportunities available for MCA Graduates?
Provide an example of a goal that you successfully attained.
What are the things you wish to achieve in 5 years?
Aptitude Test Preparation Tips
How productive are you?
How to Overcome Employment Gap during interview.
Ask Interview Question?
Have Career Question?
Ask Chandra
Ask Only Career questions.
Editorial / Best Answer
Answered by: muralidhar_batta
View all answers by muralidhar_batta
Member Since Feb-2006 | Answered On : Feb 26th, 2006
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
Varchar & Varchar2 both having the same size, & working as same.
Bt the main diff is varchar is an ANSI Datatype & Varchar2 is the Oracle datatype.
Varchar - If we declare datatype as varchar then it will occupy space for null values. It can store upto 2000 bytes of character.
Varchar2 - If we declare datatype as varchar2, it will not occupy any space. It can store 4000 bytes of character.
Thanx,