Question

text datatype in database

Forum|Forum|3 years ago
July 28, 2023
10 replies
0 views

when I set length of text 4000 . It is not show in structure.

when I save it..length not shown.

what happen length remains 4000 or become zero length

A TEXT datatype has a max size of 65,535.

navicat.com/.../1308-choosing-between-varchar-and-text-in-mysql

shifaa0002Author

why text length not shown in table as I set 4000 there

Not sure what to answer. That's just the way MySQL/MariaDB works.

You can't define a length. It is set by default at 65K.