I have one doubt in terms of Database/OS..
We know the VARCHAR is variable length Datatype. I am taking
vName varchar(20)= "Test"
so it will occupy only 4 char's memory and later 16 char's will be discarded as VARCHAR is used. But when I update the same field with "TESTDATA" then How will other 4 chars will be stored/managed ??
If any of you have idea on this issue,then let me know.