Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Answers Viewqa SQL difference between varchar & varchar2?
Login         

View Questions and Answers by Category

Advertisements


 
Have Programming Question? Ask it here!
 
 
 


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


What is the difference between varchar & varchar2?


Advertisement
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 Tutorials/Questions & Answers:
Advertisements
 

 

 

DMCA.com