Question

Which is the data type of text ?

• A. var char
• B. var char ignore case
• C. short var char
• D. Both (A) and (B)

Hint:

In SQL, the keyword is `VARCHAR`. `var char` is a common colloquialism but `VARCHAR` is the formal name for the variable-length string data type.

Answer 1

The Correct Option is A

Step 1: Identify the standard SQL data type for text. The standard SQL data type for storing variable-length strings of text is `VARCHAR`.
Step 2: Analyze the options.

(A) \text{var char}: This is a common, though slightly abbreviated, way of writing `VARCHAR`. It is the correct answer.
(B) \text{var char ignore case}: Case-insensitivity is usually determined by the table's "collation" setting, not by the data type itself. This is not a standard data type name.
(C) \text{short var char}: This is not a standard SQL data type.
The standard and universally recognized data type for variable-length text is `VARCHAR`, represented here as `var char`.