Login to manage your account

Please enter a valid email address.
Forgot Password?
Please enter a valid password.
OR

Don't have an account yet? Sign up

What is the difference between CHAR and VARCHAR?

  1. A CHAR is fixed length and space padded; VARCHAR is variable length
  2. B VARCHAR is fixed length; CHAR is variable
  3. C They are identical
  4. D CHAR can only store numbers
Answer

CHAR is fixed length and space padded; VARCHAR is variable length

CHAR always occupies its declared width. VARCHAR stores a length prefix plus the actual characters, which is more efficient for values of varying length.

All MySQL MCQs

Login to manage your account

Please enter a valid email address.
Forgot Password?
Please enter a valid password.
OR

Don't have an account yet? Sign up as