Home Answers Viewqa SQL difference between varchar & varchar2?

 
 


hemant kumar
difference between varchar & varchar2?
1 Answer(s)      2 years and 6 months ago
Posted in : SQL

What is the difference between varchar & varchar2?

View Answers

November 15, 2010 at 3:44 PM


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.









Related Pages:

Ask Questions?

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.