TEXT datatype

If i set varchar or text like this: TEXT(500) & VARCHAR(45)
What does that mean? is that max character that can be stored in the database column or what?
Thanks for quick reply :blush:

TEXT has four specific sizes - TINYTEXT (255 characters), TEXT (65,535 characters), MEDIUMTEXT (16,777,215 characters), and LONGTEXT (4,294,967,295 characters.)

In VARCHAR(m), m is the maximum number of characters and can be defined from 1 to 65,535 characters.

1 Like

Thanks :blush:
Is these values incl. spaces. Yes, i know. A space counts as a character. So i guess, but i have to ask.

You could always devise an experiment and observe the result in order to learn.

1 Like
Sponsor our Newsletter | Privacy Policy | Terms of Service