Announcement

Announcement Module
Collapse
No announcement yet.

varchar vs. text

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • varchar vs. text

    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?
Working...
X