What is the difference between the MySQL type varchar () and the text? Workaround

What is the difference between the MySQL type varchar () and the text?
What is the difference between the MySQL type varchar () and the text?

When are they used separately??

------Solution--------------------
1)
VARCHAR l+1 bytes, where l<=m and 0 <=m<= 65535
TEXT l+2 bytes, where l< 216
2)
1. Use varchar as much as possible
2. More than 255 bytes can only be used with varchar or text
3. Where you can use varchar without text
------Solution--------------------
Support the upstairs. One thing to add: when you have more general descriptive text, use text as much as possible. Using text, the fuzzy query does not affect the speed.
------Solution--------------------
cite the landlord Sf_kirk post:
What is the difference between the MySQL type varchar () and the text?

When are they used separately??

------Solution--------------------
The maximum length of the MySQL varchar is only 255.
If you want to use a varchar greater than 255, you have to use the MySQL text type.
------Solution--------------------
varchar is a restricted store text unrestricted storage, that is, text can store the varchar does not necessarily line, but varchar can store the text can certainly

Professional training jee,java,jsp, lamp series Architecture
Contact QQ492236022
------Solution--------------------
Apart from the difference in capacity, the biggest difference is in the index
------Solution--------------------
All the talk is upstairs, I'm here to pick up the points.
------Solution--------------------
discuss
Apart from the difference in capacity, the biggest difference is in the index

------Solution--------------------
VARCHAR is 256 characters in
Text is 65,536 characters in a

