difference between varchar & varchar2?

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.









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?
what is the difference between extends and implements
what is the difference between extends and implements
Difference between SCJP Exams
Difference between JSP and Servlets
difference between lock and synchronization
Difference between request.getRequestDispatcher() and context.getRequestDispatcher()
Difference between forward and sendRedirect
Difference between ServletContext and ServletConfig
Difference between translate and replace
Difference between GET and POST
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
Difference between http and https
What is the difference between a constructor and a method?
Difference between error and exception ????????
difference between applet and swings
Difference between jsonstring and json object
Difference between Struts and Spring
difference between $message and $$message
varchar & varchar2
What is difference between the java and javascript?
calculate difference between two dates
Difference between MVC1 And MVC2 - Struts
Difference between TRUNCATE and DELETE commands
Difference between and merge and update in hibernate
difference between prepared statement and statement
mysql difference between two numbers
What is the difference between a JDK and a JVM?
difference between the obj and reference - Java Beginners
What is difference between Path and Classpath?
Difference between httpService and Data Service
difference between servletconfig and servletcontext in java
difference between wite and writeto in java

Ads