Bayt.com

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.

SQL Database
user-image
Question added by Akwin Dhas
Date Posted: 2017/09/29
Upvote (0) Views (4) Followers (1) Answers (1) Report Question
Write an Answer
Register now or log in to answer.
Akwin Dhas
by Akwin Dhas

  • 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.

Write Your Answer
More Questions Like This