Question

Compare Char and Varchar datatype of SQL. ​

Answer 1

VARCHAR

1. VARCHAR is variable length.
2. It can hold a maximum of 65,535 characters.
3. It uses dynamic memory allocation.

CHAR

1. CHAR is fixed length.
2. It can hold a maximum of 255 characters.
3. It uses static memory allocation.