Differentiate between:Text(fix) and Text(Varchar) for class 10 compute

1.	Differentiate between:Text(fix) and Text(Varchar) for class 10 computer students
Answer» Answer: TEXT has a FIXED MAX size of 2¹⁶-1 = 65535 CHARACTERS. VARCHAR has a variable max size M up to M = 2¹⁶-1 . So you cannot choose the size of TEXT but you can for a VARCHAR . The other difference is, that you cannot put an INDEX (except for a fulltext index) on a TEXT COLUMN

Differentiate between:Text(fix) and Text(Varchar) for class 10 computer students

Answer»

Answer:

TEXT has a FIXED MAX size of 2¹⁶-1 = 65535 CHARACTERS. VARCHAR has a variable max size M up to M = 2¹⁶-1 . So you cannot choose the size of TEXT but you can for a VARCHAR . The other difference is, that you cannot put an INDEX (except for a fulltext index) on a TEXT COLUMN

Discussion

No Comment Found

Related InterviewSolutions

Which part of the computer is responsible for processing information and making calculations?
2. Express (12),, into its binary equivalent
What is a computer, full explanation
In which construct type is the program control transferred from a certain instruction to someother instruction depending upon the condition met?
Explain the per to per , local area network
CDRW
Ye dekho ye kiya... Amitabh Bachchan ne........ Amitabh Bachchan single h...Jaya Bachchan kha gayi ...Dhokha de diya kya ........ #ashwariya rai....hehehehe
Di m bhi karate district karate championship hu....
Thik h but jab meli mma aaegi tab .....okh#ajay
Thik h 4:30 chli jaaugi.....# ajay

Differentiate between:Text(fix) and Text(Varchar) for class 10 computer students ​

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment

Differentiate between:Text(fix) and Text(Varchar) for class 10 computer students