Question

how is varchar type different from Char ??​

Answer 1

Answer:

VARCHAR is variable length, while CHAR is fixed length. CHAR is a fixed length string data type, so any remaining space in the field is padded with blanks. CHAR takes up 1 byte per character. ... VARCHAR is a variable length string data type, so it holds only the characters you assign to it.

Answer 2

In char you can only write the alphabets and in parchar you can write the alphabets as well as numbers