I have to add 2 data fields to a table with 500,000+ rows (and growing). The data held in these fields is text and at this time, the max number of characters I’ve found users requiring in these fields is around 800, so a varchar(1000) would work as well as a text field.
The table engine is InnoDB and the data in the fields will never be searched, so no indexing is necessary.
Is there a good reason to go with one field type or the other?