What is difference between varchar and varchar2 ? Anonymous User107301-Jun-2019mssql serversql server sql sql server 2008 sql server 2012 Updated on 18-Sep-2020
Anonymous User
01-Jun-2019A Brief Comparison between varchar and varchar2
3) Allocate fixed size of data irrespective of the input.
Ex: We defined varchar (15) and entered only 10 characters. But it allocates space for entire 15 characters.
3) Allocate the variable size of data based on input.
Ex: We defined varchar2 (15) and entered only 10 characters. Then varchar2 will allocate space for 10 characters only but not for 15.