What is the main difference between VARCHAR and TEXT?

Can someone please explain the main difference between VARCHAR and TEXT?

Comments

  • TEXT is not stored in the table. Table has a pointer to the location of the physical storing location.

    VARCHAR is stored in the table. Bigger in size will make the queries slower.

Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

In this Discussion