Home » MCQs » SQL MCQs » SQL Data Types MCQs

What is the difference between VARCHAR and VARCHAR2?

20. What is the difference between VARCHAR and VARCHAR2?

1. VARCHAR can store upto 4000 bytes and VARCHAR2 can store upto 8000 bytes.
2. VARCHAR can store upto 2000 bytes and VARCHAR2 can store upto 4000 bytes.
3. Both VARCHAR and VARCHAR2 are similar but use of VARCHAR2 is mostly recommended.
4. There is no similarity between VARCHAR and VARCHAR2.

Answer: C) Both VARCHAR and VARCHAR2 are similar but use of VARCHAR2 is mostly recommended

Explanation:

Both VARCHAR and VARCHAR2 are similar but use of VARCHAR2 is mostly recommended.