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

Question

varchar and texte datatypes

Answer 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.

Answer 2

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

Answer 3

hgcdf

Answer 4

@Jeya thank you. Now I get it