The datatype Text supportsLimited variable lengthFixed variable lengthBlank paddedUnlimited variable length
Question
The datatype Text supportsLimited variable lengthFixed variable lengthBlank paddedUnlimited variable length
Solution
The datatype Text supports unlimited variable length. This means that it can hold a string of any size. Unlike fixed variable length, it doesn't have a set limit on the number of characters it can hold. It also doesn't require blank padding, which is used in some systems to fill in unused space when the data stored is less than the maximum allowed size.
Similar Questions
Which of the following data types used in SQL could be used to define a variable-length text field of 20 characters?Question 7Select one:a.char(20)b.varchar(20)c.bit(20)d.fixed(20)
Which of the following data types is used for storing text longer than 255 characters? A. short text B. long text C. number D. currency
Which SQL data type is used to store text of variable length?OptionsINTDATEBOOLEANVARCHAR
Which of the following data types in MySQL can store a text string of unlimited length? TEXTVARCHARMEDIUMTEXT LONGTEXT
What is the maximum length a text field can be
Upgrade your grade with Knowee
Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.