Question

Explain Char and Varchar datatypes.​

Answer 1

Answer:

It stores values in fixed lengths and are padded with space characters to match the specified length VARCHAR stores values in variable length along with 1-byte or 2-byte length prefix and are not padded with any characters

Answer 2

see the images...

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.