suresh CHAR Data Type: CHAR is a fixed-length data type in SQL Server that stores a specified length of characters. It always reserves the same amount of storage space regardless of the actual length of the data being stored. Any remaining space is padded with spaces.
VARCHAR Data Type: VARCHAR is a variable-length data type in SQL Server that stores a varying length of characters up to a specified maximum length. It only uses the amount of storage space needed for the actual data, without any trailing spaces.
Therefore, the main difference between CHAR and VARCHAR data types in SQL Server is that CHAR always reserves a fixed amount of storage space, while VARCHAR only uses the necessary space for the stored data, making it more efficient for storing variable-length strings.
Please login or Register to submit your answer