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
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
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