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 struts and JSF
difference between == and === operators?
Advertisements
Difference between 3d and 4d
What is the difference between the >> and >>> operators?
Difference between Timer and Thread?
what is the difference between extends and implements
what is the difference between extends and implements
difference between lock and synchronization
Difference between SCJP Exams
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
What is the difference between $message and $$message?
What is the difference between a constructor and a method?
Difference between http and https
Difference between error and exception ????????
Difference between Struts and Spring
difference between $message and $$message
calculate difference between two dates
difference between prepared statement and statement
mysql difference between two numbers
What is the difference between a JDK and a JVM?
What is difference between Path and Classpath?
difference between servletconfig and servletcontext in java
difference between wite and writeto in java
difference between enum and final class?
calculate difference between two time in jsp
DIFFERENCE BETWEEN APPLICATION SERVER AND WEB SERVER
what is the difference between distributed application and web application?
What’s the difference between load() and get()?

Ads