difference between varchar & varchar2?

Ads
 

difference between varchar & varchar2?

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.

Ads









Related Tutorials/Questions & Answers:
difference between varchar & varchar2?
Difference between DispatchAction and LookupDispatchAction
Advertisements
difference between SessionState and ViewState
difference between ForwardAction and IncludeAction
Difference between struts and JSF
difference between == and === operators?
Difference between 3d and 4d
What is the difference between the >> and >>> operators?
Difference between Mysql and SQL
Difference between Timer and Thread?
Difference between JSP and Servlets
difference between lock and synchronization
Difference between SCJP Exams
what is the difference between extends and implements
what is the difference between extends and implements
Difference between request.getRequestDispatcher() and context.getRequestDispatcher()
varchar & varchar2
Difference between forward and sendRedirect
Difference between ServletContext and ServletConfig
Difference between translate and replace
Difference between GET and POST
difference between applet and swings
What is the difference between PHP4 and PHP5?
What is difference between a PROCEDURE & FUNCTION ?
Difference between XML and HTML - XML
difference between <%@ include ...> and <jsp:include>
What is the difference between $message and $$message?
what is the Difference between weblogic and jboss?
what is the difference between pop and oop
difference between hashcode,reference in java
What is the difference between hibernate and spring

Ads