Differentiate between Text and Varchar in DBMS?
Answers
Answered by
0
Answer:
TEXT has a fixed max size of 2¹⁶-1 = 65535 characters. VARCHAR has a variable max size M up to M = 2¹⁶-1 . ... The other difference is, that you cannot put an index (except for a fulltext index) on a TEXT column. So if you want to have an index on the column, you have to use VARCHAR
Answered by
0
Answer:
A varchar or Variable Character Field is a set of character data of indeterminate length. The term varchar refers to a data type of a field in a Database Management System which can hold letters and numbers.
TEXT has a fixed max size of 2¹⁶-1 = 65535 characters. VARCHAR has a variable max size M up to M = 2¹⁶-1 . ...
Explanation:
Similar questions