In MySQL, use the ____ data type for variable-length character columns.
A)TEXT
B)VARCHAR
C)VARIABLE
D)CHARLENGTH

Question

Quizplus · Accepted Answer

VARCHAR is the best choice for variable-length character columns in MySQL because it allows for efficient use of storage space since it only uses the necessary amount of space for the data being stored. A TEXT data type is intended for larger blocks of text and consumes more storage space, while VARIABLE and CHARLENGTH are not valid data types in MySQL.

In MySQL, Use the ____ Data Type for Variable-Length Character