What is difference between varchar and varchar2

VARCHAR can store up to 2000 bytes of characters while VARCHAR2 can store up to 4000 bytes of characters.
   

If we declare datatype as VARCHAR then it will occupy space for NULL values, In case of VARCHAR2 datatype it will not occupy any space.
   

Name Varchar(10) - If you enter value less than 10, it utilize total 10 spaces.

Name Varchar2(10) - If you enter value less than 10 then remaining space is not utilize.

17 comments:

  1. AnonymousJuly 2, 2015 at 10:37 PM

    Nice article.....
    Addition to this
    What Is The Difference Between Varchar And Varchar2

    ReplyDelete
    Replies
    1. UnknownJuly 24, 2020 at 9:20 PM

      VARCHAR can store up to 2000 bytes of characters while VARCHAR2 can store up to 4000 bytes of characters.

      If we declare datatype as VARCHAR then it will occupy space for NULL values, In case of VARCHAR2 datatype it will not occupy any space.


      Name Varchar(10) - If you enter value less than 10, it utilize total 10 spaces.

      Name Varchar2(10) - If you enter value less than 10 then remaining space is not utilize.

      Delete
  2. MyJourneyInUkJune 10, 2016 at 9:47 AM

    GOOD ONE

    ReplyDelete
  3. UnknownAugust 6, 2016 at 4:21 AM

    thanks a lot...clear

    ReplyDelete
  4. UnknownAugust 31, 2016 at 3:05 AM

    thanks alot this is very helpful to me

    ReplyDelete
  5. UnknownJanuary 23, 2017 at 7:47 AM

    Thank

    ReplyDelete
  6. UnknownJanuary 23, 2017 at 7:47 AM

    Thank

    ReplyDelete
  7. UnknownApril 26, 2017 at 2:00 AM

    really it's ...good

    ReplyDelete
  8. UnknownSeptember 4, 2017 at 6:00 PM

    all the difference you mentioned above are false

    ReplyDelete
  9. UnknownApril 4, 2018 at 1:01 PM

    This comment has been removed by the author.

    ReplyDelete
    Replies
    1. UnknownApril 4, 2018 at 1:10 PM

      this is wrong answer.
      varchar:If you enter value less than 10, it utilize total 10 spaces.
      varchar2:If you enter value less than 10, it also utilize total 10 spaces.
      Both are similar,the main difference is SIZE.
      varchar size is 2000 byte
      varchar2 size is 4000 byte.

      Delete
    2. UnknownMay 17, 2018 at 12:50 AM

      Yes Mohit...

      Above statement is suitable for char function.
      In char if you have entered 10 then it utilize total 10 spaces.

      Delete
  10. UnknownFebruary 11, 2020 at 6:57 PM

    Acurate difference

    ReplyDelete
  11. sunil yadavApril 26, 2020 at 11:27 AM

    there is no difference in varchar and varchar2,oracle reserved varchar for future reference..

    ReplyDelete
  12. DEVAugust 16, 2020 at 6:41 AM

    also,varchar datatype is oracle create and varchar2 is ANSI CREATED

    ReplyDelete
  13. Vinoth KarunanithyAugust 29, 2020 at 11:10 AM

    Simply and effective answer. Thumbs up

    ReplyDelete
  14. AnonymousDecember 8, 2020 at 6:11 AM

    In addition, varchar(10) is to reserve 10 characters for use, but varchar2(10) is to reserve 10 bytes length for use. If you have entered some UTF-8 code into the data table you'll see the difference. In this scenario, varchar2(10) can just hold 3 UTF-8 encoding characters while varchar(10) accomodates the whole 10.

    ReplyDelete

Subscribe to: Post Comments (Atom)