I have two questions concerning a varchar field.
Firstly, does the varchar use up much more storage space than a normal char field. For example would a 75 charactor varchar be more efficient than storing this in a char(100)? Or is there an overhead in creating the varchar.
Secondly, does the performance of queries suffer as a result of using the varchar?
thanks
Firstly, does the varchar use up much more storage space than a normal char field. For example would a 75 charactor varchar be more efficient than storing this in a char(100)? Or is there an overhead in creating the varchar.
Secondly, does the performance of queries suffer as a result of using the varchar?
thanks