Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

What is the difference between varchar and varchar2 ?

VARCHAR is reserved by Oracle to support distinction between NULL and empty string in future, as ANSI standard prescribes. VARCHAR2 does not distinguish between a NULL and empty string, and never will. If you rely on empty string and NULL being the same thing, you should use VARCHAR2.

user-image
Question added by Akwin Dhas
Date Posted: 2017/09/29

  • VARCHAR is reserved by Oracle to support distinction between NULL and empty string in future, as  ANSI standard prescribes.
  • VARCHAR2 does not distinguish between a NULL and empty string, and never will.
  • If you rely on empty string and NULL being the same thing, you should use VARCHAR2.

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.