InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
Difference between char or varchar |
| Answer» \tSR.NO.CHARVARCHAR1.CHAR datatype is used to store character string of fixed lengthVARCHAR datatype is used to store character string of variable length2.In CHAR, If the length of string is less than set or fixed length then it is padded with extra memory space.In VARCHAR, If the length of string is less than set or fixed length then it will store as it is without padded with extra memory spaces.3.CHAR stands for “Character”VARCHAR stands for “Variable Character”4.Storage size of CHAR datatypes is equal to n bytes i.e. set lengthStorage size of VARCHAR datatype is equal to the actual length of the entered string in bytes.5.We should use CHAR datatype when we expect the data values in a column are of same length.We should use VARCHAR datatype when we expect the data values in a column are of variable length.6.CHAR take 1 byte for each characterVARCHAR take 1 byte for each character and some extra bytes for holding length information9.Better performance than VARCHARPerformance is not good as compared to CHAR\t | |