In sql for datatypes can we use VARCHAR or TEXT for the same purpose? Is there any difference between them?
varchar and texte datatypes
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.
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
@Jeya thank you. Now I get it