+ 1

What is the difference between varchar2 and varchar???

30th Mar 2017, 10:00 AM
Tanvir Ahmed Nabil
Tanvir Ahmed Nabil - avatar
2 Antworten
+ 2
They globally behave the same. VARCHAR seems to be reserved (by Oracle) for support distinction between NULL and empty string in future. So it's better to use VARCHAR2 as VARCHAR is reserved for future usage.
30th Mar 2017, 10:11 AM
Nicolas Bonnet
Nicolas Bonnet - avatar
- 1
it's almost same but varchar can take only 2000 characters where as varchar2 can take 4000 characters....
30th Mar 2017, 7:40 PM
govind