A

Admin • 833K Points
Coach

Q. Which mode does not remove trailing spaces when CHAR values are retrieved?

  • (A) PAD_CHAR_TO_FULL_LENGTH
  • (B) MEDIUMINT UNSIGNED
  • (C) CHAR_PAD_TO_FULL_LENGTH
  • (D) PAD_CHAR_TO_LENGTH
  • Correct Answer - Option(A)
  • Views: 38
  • Filed under category MySQL
  • Hashtags:

Explanation by: Admin

This question is about how MySQL handles spaces in CHAR data types. CHAR columns store fixed-length strings, meaning they always occupy the same amount of space, even if the actual text is shorter.

You must be Logged in to update hint/solution

Discusssion

Login to discuss.

Be the first to start discuss.