Thursday, 2 July 2015

What Is The Difference Between Varchar And Varchar2

Welcome to freshersjunction. In this blog, we provide answers for all technical interview questions and also provide information about software developer jobs.

Difference-Between-Varchar-And-Varchar2-images

                Here, Now the our technical interview question is “What Is The Difference Between Varchar And Varchar2 ”. For freshers this is the most important interview question.

First Difference Between Varchar And Varchar2:

If you are given varchar as data type, then Varchar can store up to 2000 bytes of characters.
If you are given varchar2 as data type, then Varchar2 can store up to 4000 bytes of characters.

So here the main difference Between Varchar And Varchar2 is storage.

Second Difference Between Varchar And Varchar2:

If you are given varchar as data type, then varchar utilize spaces for Null Values.
If you are given varchar2 as data type, then it will not take any space.

So here the main difference Between Varchar And Varchar2 space.

Third Difference Between Varchar And Varchar2:

For example if you are given data type as varchar(5) and you enter only 3 values then it utilize all 5 values. In this 3 for values and 2 for Null values (Because 2 values remain as space)

For example if you are given data type as varchar2 (5) and you enter only 3 values then it utilize only 3 values. Because in this case spaces are not considered.


Fourth Difference Between Varchar And Varchar2:

Varchar is a fixed length character data (size), where as varchar2 is variable length character data (size)

Note: Press Ctrl+D to bookmark this page. This is the most important technical interview question. If you bookmark this page, then it make easy revision for you. Before going to interview check this topic once again. All the best!!!!

You May also search in Google as :
Freshers Junction: What Is The Difference Between Varchar And Varchar2, Difference Between Varchar And Varchar2, distinguish between Varchar And Varchar2, Difference B/w Varchar And Varchar2, Difference Between Varchar And Varchar2 in Sql server, Difference Between Varchar And Varchar2 in oracle, Difference Between Varchar And Varchar2 in MySql.

2 comments:

  1. Thanks for this easy difference.........

    ReplyDelete
  2. Thank you so much for clarifying the difference..!

    ReplyDelete

 
Copyright © . Freshers Junction - Posts · Comments
Theme Template by Freshers Junction · Powered by Blogger