What is the difference between varchar and varchar2?
Oracle – the difference between varchar and varchar2 in Oracle
oraclesqldatatypes
Related Question
- Mysql – Which MySQL data type to use for storing boolean values
- Mysql – Should I use the datetime or timestamp data type in MySQL
- Sql – How to limit the number of rows returned by an Oracle query after ordering
- Oracle – Difference between a user and a schema in Oracle
- Oracle – the difference between precision and scale
- Oracle – the difference between Non-Repeatable Read and Phantom Read
- Sql – What’s the difference between RANK() and DENSE_RANK() functions in oracle
- Sql – the major difference between Varchar2 and char
Best Solution
As for now, they are synonyms.
VARCHARis reserved byOracleto support distinction betweenNULLand empty string in future, asANSIstandard prescribes.VARCHAR2does not distinguish between aNULLand empty string, and never will.If you rely on empty string and
NULLbeing the same thing, you should useVARCHAR2.