What is the main difference between VARCHAR and TEXT? - Programmers Heaven

Howdy, Stranger!

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

Categories

What is the main difference between VARCHAR and TEXT?

Jeson84Jeson84 USAPosts: 90Member

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

Tagged:

Comments

  • DavidMDavidM USAPosts: 342Member

    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.