Examveda

The datatype that means a variable length non binary string is . . . . . . . .

A. VARCHAR

B. BINARY

C. VARBINARY

D. BLOB

Answer: Option A

Solution (By Examveda Team)

This question asks about a data type in MySQL that stores text, but can have varying lengths, and isn't limited to binary characters.

Let's break down the options:

Option A: VARCHAR - This is the correct answer. VARCHAR stands for "Variable Character". It allows you to store text strings with varying lengths, and it doesn't restrict the characters to binary values. You can use letters, numbers, and symbols.

Option B: BINARY - This stores binary data. It's not suitable for storing text that might include letters or symbols.
Option C: VARBINARY - Similar to BINARY but allows for variable length, meaning you can store different lengths of binary data. Still not appropriate for text.
Option D: BLOB - This is used to store large binary data. It's not intended for text storage.

Therefore, the answer is Option A: VARCHAR. It's the ideal choice for storing non-binary text that can have various lengths.

This Question Belongs to MySQL >> MySQL Miscellaneous

Join The Discussion

Related Questions on MySQL Miscellaneous