What is the difference between varchar and varchar2?
Oracle – the difference between varchar and varchar2 in Oracle
oraclesqldatatypes
Related Topic
- 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
- Javascript .split() a string for each number of characters
Best Answer
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.