What is the maximum field size of text data type?
a) 256 b) 255
c) 225 d) 252
Answers
Answered by
3
a) 256 bytes is the maximum field size of text data type
Answered by
0
Answer:
The answer to the given question is :
a)256
Explanation:
The TEXT data type stores any text data type. It can contain both single byte and multibyte characters supported by the language. The term large object simply refers to an instance of the TEXT or BYTE data type.
A TEXT column has a theoretical limit of 231 bytes (two gigabytes) and the actual limit is determined by your available disk memory. More than 195 columns of a table cannot be declared as TEXT data type. The same restriction also applies to the BYTE data types.
You can store, retrieve, update, or delete values in the TEXT column.
You can only use the TEXT operand in a Boolean expression when testing for a NULL value with the IS NULL or IS NOT NULL operators.
#SPJ2
Similar questions