The DreamHome schema uses branchNo CHAR(4) and address VARCHAR(30) . What is the difference?

Question

The DreamHome schema uses  branchNo CHAR(4)  and  address VARCHAR(30) . What is the difference?

Accepted Answer

CHAR(4) always occupies 4 characters; VARCHAR(30) uses only as many characters as needed, up to a maximum of 30.

Answer

There is no difference — the two declarations are interchangeable.

Answer

VARCHAR(30) always occupies 30 characters, exactly like CHAR(4) occupies 4.

Answer

CHAR is for numeric codes and VARCHAR is for text; they cannot be compared.

Crowdly