Type of field in the database for user posts

What type of field should be in the database where the user drops the message: VARCHAR(32)or TEXT?

Which is better?


Answer 1, authority 100%

Depends on whether you’re going to somehow limit users in the length of their message. If you are not going to, then you can use TEXT.

In any case, I would put the text and not bother.

PS: definitely not VARCHAR(32). Would you like to have your posts cut to 32 characters? 🙂


Answer 2, authority 100%

VARCHAR(32)means text with a maximum of 32 characters. TEXT– 64kb. Which option is better for your system, choose for yourself.


Answer 3, authority 50%

Look how limited the number of characters for a message.