
What is the difference between varchar & varchar2?

hi,
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.
Varchar is used to store alphanumeric values without padding the unused memory locations whereas Varchar2 is also used to store alphanumeric values with padding the unused memory locations. So, by using varchar2 we are saving the memory locations.
If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.
Ask your questions, our development team will try to give answers to your questions.