+ 3
What is the difference between char and varchar
3 Answers
+ 1
every character we store occupies a specific size ..
where as in varchar the remaining size can be occupied...
ex: for example suppose assume we have give size of character array 20 and we have only give 10 elements ,then the remaining size will be wasted
where as when we declared varchar of size 20 and
stored size of 10,the remaining size will not be wasted and can be used for another elements ...
+ 1
char is fix datatype
vrchar is no fix length