Char vs Varchar
The CHAR is a data type with fixed length.
The CHAR uses the entire declared length even if fewer characters are stored in the variable.
The CHAR loads empty spaces.
The VARCHAR is a data type with variable length.
The VARCHAR does not use the entire declared length.
The VARCHAR uses only the length loaded with characters.
The Char and Varchar length must be a value from 1 through 8,000.
Example
DECLARE
@v_Char Char(10) = 'abcde',
@v_Varchar Varchar(10) = 'abcde'
SELECT
DATALENGTH(@v_Char) CharLen,
DATALENGTH(@v_Varchar) VarcharLen;
Results
CharLen | VarcharLen |
---|---|
10 | 5 |