What is the difference between char and varchar | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
+ 3

What is the difference between char and varchar

29th Sep 2017, 2:22 AM
uday samineni
uday samineni - avatar
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 ...
29th Sep 2017, 2:28 AM
Satwik Dondapati
Satwik Dondapati - avatar
+ 1
char is fix datatype vrchar is no fix length
1st Oct 2017, 10:40 PM
Nikhil Manik
Nikhil Manik - avatar