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
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.
+ 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
0
hgcdf
0
@Jeya thank you. Now I get it