Question

similarity of char and varchar

Answer 1

The char is a fixed-length character data type, the varchar is a variable-length character type. Because char is fixed-length data type, the storage size of char value is equal to the maximum size for this column. we can use the char when the data entries in a column are expected to be the same size.