Why I can't limit the length of TEXT type in phpmyadmin?

Hi guys,

Why I can’t limit the length of TEXT type in phpmyadmin?
Is this a bug?

I entered like this,

type: TEXT
length/values: 5000

and also I tried like this,
type: TEXT
length/values: 5,000

When I view the structure of the table it shows like this,

text

Isn’t it suppose to be look like this?,

text(5000)

Can someone explain please.

those numbers in parentheses behind some datatypes might be making you think that they somehow “limit” the number of characters or digits that the column can hold

this is ~not~ what they do for integer datatypes

INT(4) and INT(10) and INT(937) will all hold exactly the same range of numbers

the numbers in parentheses behind CHAR and VARCHAR are required and ~do~ limit the length of the values

numbers in parentheses behind TEXT and BLOB and their similar datatypes are not permitted

@r937 ;
It’s really nice to hear the answer from a master.
Thanks again master.

By the way, so what is the use of the integer length?


INT(4) and INT(10) and INT(937)

If you use it with a padding option then the number gets padded out to the specified length if it is shorter. If you don’t use it with a padding option then it makes no difference at all.

specifically, ZEROFILL

Thanks guys.