0

In sql for datatypes can we use VARCHAR or TEXT for the same purpose? Is there any difference between them?

varchar and texte datatypes

21st Feb 2017, 9:35 AM
RICKMAN
RICKMAN - avatar
4 Answers
+ 1
We can use VARCHAR if the string uses the characters less than the count 4000, If we want a string more than that length, we can use TEXT.
21st Feb 2017, 6:35 PM
Jeya lakshmi
Jeya lakshmi - avatar
+ 1
Text is stored off the table with the table just having a pointer to the location of the actual Varchar is stored inline with the table. Varchar is faster when the size is reasonable
22nd Feb 2017, 4:38 AM
Wannisa Paethong
Wannisa Paethong - avatar
0
hgcdf
21st Feb 2017, 10:43 AM
Jatin neelay
0
@Jeya thank you. Now I get it
21st Feb 2017, 7:01 PM
RICKMAN
RICKMAN - avatar