Difference between TEXT and VARCHAR in MySQL

MySQL TEXT type has the following features:

• cannot have a DEFAULT value
• fixed max size of 65535 characters (no chance to customize the max size)
• cannot be part of an index as entire column, prefix length must be specified

MySQL VARCHAR(N) type has the following capabilities:

• can have a DEFAULT value
• variable max size of N characters (1 <= N <= 65535)
• can be part of an index

Have questions? Contact us